mysql: root access denied ~ driving me nuts!

everything was working well until i changed permissions on root (i'm stupid) and now mysql sees root as anon. user. root only has access to test db and nothing else. how can i give root back it's god status to all db's?

 

Is there another user in your MySQL setup with root alike rights you can use to restore root?

 

Hi,

Unfortunately, there isn't. I am open to any suggestions that can resolve this issue.

thanks

 

See http://lists.mysql.com/mysql/171366

 

Thank you martinfst. That pointed me to the right direction. Though that post was old, i just had to use service mysqld stop, which allowed me to continue the rest of the way. I did have some problems with the other commands. Luckily, I had webmin installed and headed over to the MySQL Database Server section and changed the password there.

regards