Re: [webmin-l] Access denied for user: '@localhost' in MySQL

[Jamie C. <jca...@we...>]

On Thu, 2005-01-20 at 11:38, Sharon Kimble wrote:
> I installed MySQL version 3.23.58 using yum and rpms, and then created a
> 'testpad' database through webmin just to see how it worked. On the next
> time of opening and looking at it I tried to access the user section under
> 'Global Options' and got this reply;- 'DBI connect failed : Access denied
> for user: '@localhost' to database 'mysql''
> 
> It has all been done through webmin, so how do I regain control of things
> please? I've googled for an answer, and I've looked on the MySQL website, but 
> I can't see anything that appears to work. If it helps I can easily remove 
> MySQL if necessary providing someone can tell me exactly what to delete to 
> wipe out all traces of it including the password.

It looks like Webmin is logging into MySQL as the wrong user - one who
doesn't have permissions to manage other users. CLick on the Module
Config link, and make sure the login and password are set correctly -
you should be connecting as 'root' with the MySQL root password. 

Often due to the existance of an 'anonymous' entry in the MySQL users
list you will be able to connect even with an invalid login or password.
However, an anonymous login typically cannot do very much. For this
reason, I recommend deleting those anonymous users if possible ..

 - Jamie