Access denied to mysql ?

15 posts / 0 new
Last post
#1 Tue, 06/09/2009 - 05:30

Access denied to mysql ?


I have double checked my user and password both in my script and on the virtualmin control panel.

the script data is the same as what I have assigned via virtualmin - edit databases and yet I still get this message:

Access denied for user 'ew78gt'@'localhost' (using password: YES) ...

Couldn't connect to server.Access denied for user 'ew78gt'@'localhost' (using password: YES)

How can I sort this out ?

Tue, 06/09/2009 - 09:01

If you log into the command line interface, and type:


And then enter your password when prompted, does that allow you into MySQL? -Eric

Tue, 06/09/2009 - 09:30


I get:

ERROR 1045 (28000): Access denied for user 'ew78gt'@'localhost' (using password: YES)

I changed the password for that user to a new one (being very careful)

But it di not work.

I still get the same errror

Tue, 06/09/2009 - 10:54

Yeah, it definitely sounds like something may be awry with the password.

If you go into Edit Databases -> Passwords, what option is it set to now? -Eric

Tue, 06/09/2009 - 11:17

It is set to: Same as administration

Tue, 06/09/2009 - 11:22


In theory that should work.

But it's not, so lets try plan H. (I'd try plan B, but it would be ready for that, we need to keep it on it's toes).

Try clicking "Custom Password", and enter the password you want to use in that field. Hit "Save", and see if that does the trick for you. -Eric

Tue, 06/09/2009 - 11:32

I think I tried that one before I opened this thread.

OK - I have just tried it again and I still get:

ERROR 1045 (28000): Access denied for user 'ew78gt'@'localhost' (using password: YES)

Tue, 06/09/2009 - 12:54

Any more ideas ?

I am still locked out of my mysql database :(

Tried rebooting the mysql server but it did not help.

How about plan K ?

Tue, 06/09/2009 - 13:41 (Reply to #8)

If you go into Edit Databases -> Remote hosts , what names show up in there? -Eric

Tue, 06/09/2009 - 15:19

It shows "localhost"

Now I seem to remember that last time I had this problem, I think that I had to edit some .conf file.

That is why I wanted to look up all my previous threads because I can not remember what we edited. Something had to be commented out in a file.

But I thought that what we did was for my whole server - but maybe it was for only one virtual server.

Hopefully you can remember what this might be :)

Wed, 06/10/2009 - 12:48 (Reply to #10)

Well, it's a problem if you can go into Edit Databases, change the password, and not have it actually change.

That sounds very bug-like to me ;-)

I think I'd recommend filing a bug report in the (new and shiny!) bug tracker, and we'll see if Jamie has some thoughts on all that. -Eric

Fri, 06/12/2009 - 03:38


I have "cured" this by saving the remote hosts info again ( localhost)


Fri, 06/12/2009 - 07:58

Hrm, that's odd!

But, I'm glad you got it figured out. -Eric

Thu, 03/09/2017 - 05:30
unborn's picture

Hi, I have same issue after update on debian. existing dbs working fine but new one I cannot log int not even via phpmyadmin.. changing passwords does not help even if I update permissions..

Configuring/troubleshooting Debian servers is always great fun

Tue, 04/02/2019 - 04:34

I got this problem with my server too. I was playing arround laravel first I setup domain everything was great after I tried to connect over with my HEIDI SQL client I got error what you all have talked about above. And then I changed host connection type yo any laravel could not connected then. After I added same user name and password from User Permissions with address I both connected from with HEIDI and localhost requests. Have a nice play with your codes :)

Topic locked