Error in Database Servers: Access denied for user 'admin'@'localhost'

Refers to:

  • Plesk 12.0 for Linux

Created:

2016-11-16 13:19:42 UTC

Modified:

2016-12-21 20:28:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error in Database Servers: Access denied for user 'admin'@'localhost'

Symptoms

Can not connect to MySQL database, the following error can be found in Tools & Settings > Database Servers :

Access denied for user 'admin'@'localhost'

Solutions from

did not help to resolve the issue.

Cause

Database inconsitency

Resolution

~# plesk db

mysql> begin;
mysql> UPDATE DatabaseServers SET admin_password='********' WHERE type='mysql' AND admin_login='admin' AND host='localhost';
mysql> commit;
Have more questions? Submit a request
Please sign in to leave a comment.