Posted by:
Millsey
(---.in-addr.btopenworld.com)
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