Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000)

[J.Wick]

Plesk 11.09
Centos 5.9
MySQL 5.5.32-19

When I try to shut down Plesk or restart it I get this this error:

# /etc/init.d/psa restart
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Also, scheduled backups fail, because of a MySQL password issue, so I'm assuming these issues are connected.

How do I sync the password? I tried resetting the admin password through Plesk and it had no affect, which is also only letters and numbers, no special symbols.

 

[IgorG]

Have you tried to search it in KB articles. There are a lot of mentions "Access denied for user 'admin'" for example...

 

[InderS]

Are you able to login MySQL with the following command?

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa

 

[J.Wick]

Are you able to login MySQL with the following command?

Yes, no problem.

• I connect to MySQL at the CLI.
• I've always been able to login as admin to the panel.
• I've reset the password in the panel, no effect.
• I've rest the password at CLI using http://kb.parallels.com/en/346 and http://kb.parallels.com/112492, no effect.

Every time I try to restart, stopall, and start PSA I get:

[root@vcloud ~]# /etc/init.d/psa restart
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

If I set "skip-grant-tables" everything works fine.

So my puzzlement is where is the password being stored that PSA is using to connect to MySQL and how can I correct it?

 

[IgorG]

Use /usr/local/psa/admin/bin/ch_admin_passwd for resetting admin's password.

 

[J.Wick]

Use /usr/local/psa/admin/bin/ch_admin_passwd for resetting admin's password.

I did the reset again with this method, using only 14 char password and got the output.

# /usr/local/psa/admin/bin/ch_admin_passwd
mysqld: no process killed

Tested the new password and was able to login to Plesk.

However, problem persists at the CLI.

[root@cloud ~]# /etc/init.d/psa stopall
Stopping psa... done
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Plesk: Stopping Mail Server... done
Stopping mailer service... not installed
Stopping mysqld service... done
Stopping postgresql service... done
Stopping psa-spamassassin service... not installed
Stopping tomcat5 service... done
Stopping httpd service... done

[root@cloud ~]# /etc/init.d/psa start
Starting xinetd service... done
Starting mysqld service... done
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Refusing to reset instance-specific data.
Starting named service... done
Starting postgresql service... done
Starting psa-spamassassin service... not installed
Plesk: Starting Mail Server... done
Starting psa... done

I've been using and administering Plesk for a long time, there is something going on here that is most likely a bug.


I have a hunch that I need to delete the admin user and have that account re-created. Is that even possible and what would the best way of doing that?

 

[InderS]

Can you please try to reset your admin password with : http://kb.parallels.com/en/346

 

[J.Wick]

Can you please try to reset your admin password with : http://kb.parallels.com/en/346

I did that before, didn't work. I just did it again with the same result.

[root@cloud ~]# /usr/local/psa/bin/admin --show-password
xxxxxxxxx
[root@vcloud ~]# /usr/local/psa/bin//init_conf -u -passwd xxxxxxxx

SUCCESS: Completed updating administrator's information.
[root@cloud ~]# /etc/init.d/psa restart
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@cloud ~]#

 

[J.Wick]

So I'm guessing that due to the lack of other suggestions I've discovered a bug.

Where can I report this or get further detailed help?

I can't upgrade until this is corrected, I have a feeling if I tried, it would kill the entire server.