Help! I've locked the root account out of my database.
The stupid thing I did was in webmin, I was looking at a list of user permissions in my database, and saw a few entries for "root". I noticed there was one which gave root access to all databases, and one that gave access to only on database. I stupidly removed access to the one database, now when I try to do anything, I get this error.
Access denied for user 'root'@'localhost'
I've tried restarting mysql with "skip-grant-tables" which allows me to view/edit all the databases, but I still can't run the command (GRANT ALL on *.* to 'root'@'localhost'), to put the permissions back. (mysql gives me the error that I can't run GRANT statements since I'm using skip-grant-tables"
Can someone help me restore access to all db tables to my root account, keeping all my databases and existing users intact?