"Reset Local MySQL Root Password" does not work.

[gopederick]

I did a search and got this http://forums.cpanel.net/showthread.php?t=23696 But it doesn't answer my problem so I will post a new thread.

Now for my problem.

Hi, I am having this same problem. When I click Add Db button it says it did, but when it returns back the page it shows no created database.

1. MySQL is running. Forums and my gameserver plugins are working.
2. I can not Reset Local MySQL Root Password. It says it did it but I can not access mysql via shell or phpmyadmin.

So I did a make deinstall for mysql 4.0.13 and installed 4.0.21 and I still get the same problem.

Any ideas on how I can reset the mysql password so it works?

[gopederick]

^ bumpage ^

[gopederick]

^ more bumpage ^

[paolorulez]

try


pico /root/.my.cnf

set user and your pass without ""

after
mysql> FLUSH PRIVILEGES;
restart mysql


another method

shell> mysql -u root



mysql> UPDATE mysql.user SET Password=PASSWORD(newpwd)
-> WHERE User=root;
mysql> FLUSH PRIVILEGES;
restart mysql

[gopederick]

yay it worked.! many thanks! removing the quotes did it! thanks again ^_^