mysql: root access denied ~ driving me nuts!

[domino]

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?

[martinfst]

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

[domino]

Hi,

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

thanks

[martinfst]

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

[domino]

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