[FIX] Cannot configure Client MySQL server in Plesk

Created:

2016-11-16 13:16:18 UTC

Modified:

2017-04-24 11:13:45 UTC

1

Was this article helpful?


Have more questions?

Submit a request

[FIX] Cannot configure Client MySQL server in Plesk

Applicable to:

  • Plesk for Windows

Symptoms

When attempting to configure connection to client MySQL server in Plesk the following error is displayed:

    Failed to connect to database: Access denied for user ‘admin’@’localhost’.

Cause

This problem occurs when Plesk connection to MySQL server used for clients’ databases is incorrectly configured.

Resolution

To configure it back you need to complete the following steps:

  1. Edit MySQL configuration file my.ini located within %plesk_dir%databases\mysql\data .

  2. Add parameter skip-grant-tables into the [MySQLD] section.

  3. Restart SQL Server.

  4. Log into MySQL.

    "%plesk_dir%\\mysql\\bin\\mysql.exe" mysql
  5. Execute the following query:

    mysql> update user set password=password('current_password') where user='admin';
  6. Remove skip-grant-tables from within the [MySQLD] section within %plesk_dir%\databases\mysql\data\my.ini .

  7. Restart MySQL Server.

Where current_password is the password of admin in client MySQL which is stored in Plesk. It is used by Plesk to control client MySQL server. The current password used by Plesk can be retrieved from the Plesk database using the query below:

    %plesk_dir%\\mysql\\bin\\mysql -uadmin -p`pleskadmin_password` -P8306 psa
mysql> select val from misc where param=’mysql_admin_passwd’;

Note : Starting from Plesk 8.x this password is stored in different database: DatabaseServers.

So, e,g, in case of using Mysql as database provider you can use the following command to retrive login and password to client mysql server:

    select * from DatabaseServers where type='mysql'
Have more questions? Submit a request
Please sign in to leave a comment.