MySQL server is in disconnected state.

Created:

2016-11-16 13:24:35 UTC

Modified:

2017-08-08 13:40:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MySQL server is in disconnected state.

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

MySQL server is in disconnected state in Plesk > Tools & Settings > Database Servers . The following error occurs if navigate to Local MySQL Server > Databases tab:

Error: Access denied for user 'admin'@'localhost' (using password: YES)

Cause

Incorrect value of admin_password field in psa.DatabaseServers table for MySQL databsae server. It should be ******** .

Resolution

  1. Create backup of psa database

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin psa > psa`date +%F_%H.%M`.sql
  2. Find corresponding entry for mysql database server. In general it has id=1 :

    mysql> select id, type, port, admin_password from DatabaseServers where type='mysql' and port='3306';
    +----+-------+------+------------------------------------------------------------------+
    | id | type | port | admin_password |
    +----+-------+------+------------------------------------------------------------------+
    | 1 | mysql | 3306 | $AES-128-CBC$GCZ+0R90E8+/5tlMziaXXA==$M4vqzWlx3jqJyZTyrjTZMA== |
    +----+-------+------+----------------+-------------------------------------------------+
  3. Update psa database with the following query:

    mysql > update DatabaseServers set admin_password='********' where id=1;
Have more questions? Submit a request
Please sign in to leave a comment.