Search

Language:  
Search for:

Available article translations:

[FIX] Cannot configure Client MySQL server in Plesk

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’.

Resolution

This problem occurs when Plesk connection to MySQL server used for clients’ databases, is incorrectly configured. 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'





FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 9 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification