After the failed upgrade attempt, Plesk utilities fail with: PleskMainDBException The server requested authentication method unknown to the client

Created:

2016-11-16 13:14:12 UTC

Modified:

2017-08-16 16:02:24 UTC

0

Was this article helpful?


Have more questions?

Submit a request

After the failed upgrade attempt, Plesk utilities fail with: PleskMainDBException The server requested authentication method unknown to the client

Applicable to:

  • Plesk 11.x for Windows

Symptoms

After the failed upgrade attempt, Plesk utilities fail with the following error:

PleskMainDBException: The server requested authentication method unknown to the client
file: E:\\Parallels\\Plesk\\admin\\plib\\db.php
line: 451
code: 0
trace: #0 E:\\Parallels\\Plesk\\admin\\plib\\db.php(411): reconnect()
#1 E:\\Parallels\\Plesk\\admin\\plib\\auth.php(137): db_connect()
#2 {main}

The dbclient.exe utility fails to execute SQL queries with the following error:

Failed to connect to database: Can't connect twice. Already connected
at (MySQLDatabaseProvider::connect line 199)

Cause

There are two entries for admin user in Plesk database. One with '%' in the 'host' field, the second one with 'localhost' :

mysql> select user,host from user where user='admin';
+-------+-----------+
| user | host |
+-------+-----------+
| admin | localhost |
+-------+-----------+
| admin | % |
+-------+-----------+

Resolution

  1. Create psa backup according to:

213904125 How to backup/restore a Plesk database dump?

  1. Access psa database according to:

213928465 How to access Plesk database?

  1. Remove the entry with '%' value in 'host' field:
    mysql> delete from user where host=%;
Have more questions? Submit a request
Please sign in to leave a comment.