Error::DBI connect failed : Access denied for user ''@'localhost' to database
'mysql'
I am using webmin tool for managing the mysql database installed in
fedora 9 machine.I am able to login with mysql administrator username
root and password null.But actually the password i assisgned for the
mysql administrator was root .I did it in module configuration of
webmin.But it is not taking effect.I am able to login with username
root and password null(but not able to create database or any of the
mysql commands).For anything i try i am getting the error message
DBI connect failed : Access denied for user ''@'localhost' to database
'mysql'
I tried to uninstall mysql and reinstalling but nothing in
favour.Please help me in this regard.Thanks
Sounds like your MySQL database has an anonymous account which is allowing login even when the root password Webmin is using is wrong..
Make sure Webmin is setup to login using the correct root password. This is set on the Module Config page, linked from the main page of the MySQL module.