Access denied to mysql ?

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

Access denied to mysql ?

Hi,

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
andreychek

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

mysql -u YOUR_MYSQL_USERNAME -p

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

Tue, 06/09/2009 - 09:30
Davvit

No,

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
andreychek

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
Davvit

It is set to: Same as administration

Tue, 06/09/2009 - 11:22
andreychek

Okay.

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
Davvit

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
Davvit

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)
andreychek

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

Tue, 06/09/2009 - 15:19
Davvit

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)
andreychek

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
Davvit

OK

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

Thanks

Fri, 06/12/2009 - 07:58
andreychek

Hrm, that's odd!

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

Thu, 03/09/2017 - 05:30
unborn
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.. https://virtualmin.com/node/49928

Configuring/troubleshooting Debian servers is always great fun

Tue, 04/02/2019 - 04:34
Coffeedokie

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 127.0.0.1 address I both connected from with HEIDI and localhost requests. Have a nice play with your codes :)

Topic locked