Hey,

I'm messing around with mysql-databases in webmin.
I changed the user-permissions :

root was only available from localhost, I changed it to all hosts, but that was a big mistake. This is the error I get :

DBI connect failed : Access denied for user: '@localhost' to database 'mysql'


I can't do or change anything anymore, and my databases aren't visible in webmin (only 1 : test). Even the standard database mysql isn't visible. What can I do ???

I hope someone can help me, because I'm really desperate !!!


Thanks !!!

PS: I tried to change a password in the shell, with the command :

mysqladmin -u root password 'password'

but it says :

mysqladmin: unable to change password; error; 'Access denied for user: '@localhost' to database 'mysql'

Help please !!!!

try logon to mysql: mysql -u root -p

I can login to mysql, but I can't change something, always same error .

I hope it wasn't a fatal mistake

Restart mysqld with the option --skip-grant-tables, then fix the user table in the database mysql. Follow the instructions in the manual: http://www.mysql.com/doc/en/Resetting_permissions.html