MySQL root user problems

[tcarradine]

Okay, so I accidentally removed ALL privileges from root using Webmin. is there any way I can allow root access again (I can no longer use Webmin or phpmyadmin) help!

Tim

[MunterMan]

Bit of searching turned this up at
www.webmin.com
Looks like they were just waiting for you!

__________________________________________________ ____
How do I change my Webmin password if I can't login?

Included with the Webmin distribution is a program called changepass.pl to solve precisely this problem. Assuming you have installed Webmin in /usr/local/webmin-1.140, you could change the password of the admin user to foo by running

/usr/local/webmin-1.140/changepass.pl /etc/webmin admin foo
__________________________________________________ _____

[mdwatts]

/usr/local/webmin-1.140

Of course you may need to modify the Webmin path to wherever yours is installed.

[tcarradine]

okay... really sorry... i'm not having problems getting into webmin, but into mySQL. i removed all root privileges from mySQL USING webmin... sorry to be confusing. anything i can do?

Tim

[mdwatts]

Can you logon to MySQL using the commandline 'mysql' using the admin account and then restore the root privileges?

G4L search results for 'mysql user admin' (http://www.google.com/linux?hl=en&lr=&ie=ISO-8859-1&q=mysql+user+admin&btnG=Google+Search) may help or the MySQL documentation/faq's etc. at www.mysql.com