Posted by Tito on 10/18/06 01:55

I found inserting a root password using phpMyAdmin priveleges was
buggy.
So, I recommend using the old fashioned way.

If you can access MySQL in DOS ...
cd \mysql\bin
mysql -u root mysql

Otherwise you can use the SQL section of phpMySQL ...

UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE user='root';
FLUSH PRIVILEGES;
QUIT

[Back to original message]