Changed my root user access for mysql access to Any from localhost
I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping i can change it by command line or if i can access the config files and change it that way?
|
Can you run mysql from the command line? If so, check to see if you only have one entry for 'root' in your mysql database, in the user table. You can check it with:
Code:
# mysql -u root -p Once you've verified root@localhost works, then you can drop root@% Or if you see that you do have an entry for 'root'@'localhost' and you need to change your root password, see the article at http://www.howtoforge.com/setting-ch...root-passwords |
Quote:
|
All times are GMT -5. The time now is 01:23 AM. |