- Plesk Onyx for Windows
- Plesk 11.x for Windows
- Plesk 12.0 for Windows
- Plesk 12.5 for Windows
During an upgrade, Plesk needs to connect to the local MySQL server. If it's not possible, the upgrade fails:
CONFIG_TEXT: WARNING: [MYSQL ERROR] Unable to connect to database. the reason of problem:
ERROR: The system was not able to find the specified registry key or value.
WARNING: Default MySQL server is not registered in Plesk. If you use custom MySQL instances you should register one at least according to article /en/111983
Plesk is not able to connect to the database.
Connect to the server via RDP and make sure that it is possible to connect to the local MySQL server with this command:
C:\> "%plesk_dir%\\MySQL\\bin\\mysql.exe" -uadmin -p<password> -hlocalhost -P3306
The password can be obtained by this command:
C:\> "%plesk_bin%\\dbclient.exe" --direct-sql --sql="select * from databaseservers where type='mysql' and host='localhost'"
id host port type server_version admin_login admin_password parameters_id last_error
1 localhost 3306 mysql 5.5.15 admin e*********e no_error
If it is still not possible to login to MySQL server with credentials, it is required to change credentials in
to validate MySQL server. It is possible to do with this command:
C:\> "%plesk_bin%\\dbclient.exe" --direct-sql --sql="Update databaseservers set admin_login='<MySQL user name>', admin_password='<type password here>' where host='localhost' and type='mysql'"
<MySQL user name> - it is the name of the user with all privileges.