phpMyAdmin

[dayjahone]

I just changed my mysql password using

mysqladmin -u root -pcurrent_password password new_password

and now I can't login to phpMyAdmin at all. I tried using the client username and password, and I tried "root" and the mysql admin password. I tried "root" and the old password. What am I doing wrong?

[till]

Are you able to login with the "mysql" command on the shell?

[dayjahone]

I can log on just fine as the system user. When I try as root, I get the error:

ERROR 1045 (28000): Acess denied for user 'root'@'localhost' (using password: NO)

[falko]

Have you tried to restart MySQL?

[dayjahone]

I restarted mysql and I restarted the machine. I can now log in as root using the new password, but I am supposed to be able to login using my client login information as well, right? I am still not able to do that.

Is there anywhere else I need to change the password? I did the following:

mysqladmin -u root -pcurrent_password password new_password

then, to change it on the line

$go_info["server"]["db_password"] = "new_password";

in /home/admispconfig/ispconfig/lib/config.inc.php

Another thing I notice is when I click to logout of phpMyAdmin it asks me for a username and password again and won't accept anything I give it. I eventually just close the window.

[falko]

Do you see any MySQL errors in the syslog?
Does your new password contain any special characters?

[dayjahone]

Where is the syslog?

There is one special character in the new password, but, like I said, I can log in as root, so I'm guessing that's not the problem.

[dpakulski]

I think I know where the problem might be. You set password to mysql root account and before access from localhost was without any password. I'd advice to configure root account permission in mysql that password from localhost is not required. All should come back to previous state after that.

I can't give you now more precise instruction how to do it, but using man pages I suppose it should take 2-5 min to reset mysql root account permission to state that password from localhost is not required providing you know current root mysql password.

[dayjahone]

Uh...so, how can I fix it?

[falko]

Try this to set another password: http://www.howtoforge.com/reset-forg...-root-password