Plesk Panel upgrade is failing with ERROR while trying to upgrade MySQL password format for phpMyAdmin control user

Created:

2016-11-16 13:05:03 UTC

Modified:

2017-08-16 16:06:22 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk Panel upgrade is failing with ERROR while trying to upgrade MySQL password format for phpMyAdmin control user

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 10.x for Linux
  • Plesk 11.x for Windows
  • Plesk 11.x for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

Plesk Panel upgrade is failing with error below:

 Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.9.5.4-11.0.9.20131021-154506.dump.gz
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

ERROR while trying to upgrade MySQL password format for phpMyAdmin control user
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

***** problem report *****
ERROR while trying to upgrade MySQL password format for phpMyAdmin control user
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

Cause

Unexpected '/root/.my.cnf' file with a MySQL password.

Resolution

  1. If '/root/.my.cnf' file is present then use solution provided in knowledge base article #213928585

  2. If you do not have '/root/.my.cnf' you can reset user password manually:

    mysql> begin;
    mysql> UPDATE mysql.user SET Password = password('password') WHERE User = 'dbbackupuser';
    mysql> UPDATE mysql.user SET Password = password('password') WHERE User like 'pma_%';
    mysql> commit;

Where 'password' is the database password. You may refer to following KB article in order to find out the password that Plesk uses to connect phpMyAdmin database: /en/213933965

Have more questions? Submit a request
Please sign in to leave a comment.