These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for Access denied to mysql ? on the new forum.
Web Hosting and Cloud Computing Control Panels
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
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
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
It is set to: Same as administration
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
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)
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 ?
If you go into Edit Databases -> Remote hosts , what names show up in there? -Eric
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 :)
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
OK
I have "cured" this by saving the remote hosts info again ( localhost)
Thanks
Hrm, that's odd!
But, I'm glad you got it figured out. -Eric
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
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 :)