SQL access problem

[nibs]

Hi,

I have been at this problem for a while.

I have tried to reset the root password in MySQl Version 3.23 using (assume I am in MySQL Monitor)

mysql ->GRANT ALL PRIVILIGES ON . TO "root"@"localhost"
->IDENTIFIED BY "the_New_Password";

Yet I get Error 1047 unknown command.

the reason I need to solve this is b/c in some php pcode I am using :

$db_host = "localhost";
$db_user = "root";
$db_pass = "the_new_password";
$db_name = "test";

I need to know the root password.

Thank you in advance for any help.

Nibs
$

[shiokie]

try this site

http://www.mysql.com/doc/en/Resetting_permissions.html

The passwords in mysql are encrypted, it might be that problem.

[nibs]

Thank you I will take a look at that site and let you know if it worked. Thank you for the assistance. I greatly appreciate it.

Nibs