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

Created:

2016-11-16 13:19:42 UTC

Modified:

2017-08-08 13:39:01 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.0 for Linux

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.