error 1064! Can't change root!
Posted by: Millsey (---.in-addr.btopenworld.com)
Date: January 10, 2006 01:11PM

I have installed WAMP 1.6.0 and I am having trouble setting the root password. I have tried the following solution posted by Tom:

1) Edit php.ini and populate 'mysql.default_password' with a password.
2) Open the MySQL console, for the 'Enter the password' prompt just hit enter.
Then execute:

SET PASSWORD FOR root@localhost=PASSWORD('whatever');
EXIT;

Replace 'whatever' with your password.

3) Edit C:\wamp\phpmyadmin\config.inc.php.

Enter the password in the '$cfg['Servers'][$i]['password']' field.

4) Restart everything.

HOWEVER, when i excute instruction (2) i get the following error:

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax"

can anyone help?????]

Many thanks

Options: ReplyQuote
Re: error 1064! Can't change root!
Posted by: Bilal (---.upc-f.chello.nl)
Date: January 10, 2006 03:41PM




Undo all of your faults, and make you're password in the phpMyAdmin area.....


bilal.

Options: ReplyQuote


Sorry, only registered users may post in this forum.