system
June 9, 2009, 10:30am
1
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 ?
Eric
June 9, 2009, 2:01pm
2
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
Eric
June 9, 2009, 3:54pm
4
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
Eric
June 9, 2009, 4:22pm
6
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 ?
Eric
June 9, 2009, 6:41pm
9
If you go into Edit Databases -> Remote hosts , what names show up in there?
-Eric
system
June 9, 2009, 8:19pm
10
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
Eric
June 10, 2009, 5:48pm
11
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
system
June 12, 2009, 8:38am
12
OK
I have “cured” this by
saving the remote hosts info again
( localhost)
Thanks
Eric
June 12, 2009, 12:58pm
13
Hrm, that’s odd!
But, I’m glad you got it figured out.
-Eric
unborn
March 9, 2017, 11:30am
14
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
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