Plesk autoinstaller shows the following error during upgrade: "Passwords for some MySQL users were not upgraded"

Created:

2016-11-16 13:14:34 UTC

Modified:

2017-08-16 16:41:52 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk autoinstaller shows the following error during upgrade: "Passwords for some MySQL users were not upgraded"

Applicable to:

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

Symptoms

Plesk autoinstaller shows the following error during upgrade:

...
Passwords for some MySQL users were not upgraded.
All MySQL DB users that may be used by Panel MUST have passwords in new 41-character format in order for Panel to function properly.
Currently following users have passwords in old format: pma_sGBE053PIf8J@localhost.
Please ensure that MySQL server is not forced to use old password hashing algorithm and upgrade password format manually for users from the list above. Consult with MySQL server manual on detailed steps.
You may skip certain users if you are sure they weren't created and aren't used by Panel.
ERROR while trying to upgrade SQL database from 860
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

Cause

Old version of Mysql server which does not support 41-character password format is installed.

Resolution

  • Make sure the currently istalled package is equal or higher 2.elX.art .

    # rpm -qa | grep mysqlclient | xargs rpm -q --queryformat '%{RELEASE}\

    ' # 2.el6.art

  • If the version is older then update mysqlclient package to the latest release:

    # rpm -qa | grep mysqlclient | xargs yum update
  • After update is complete, rerun this utility to complete the upgrade:

    # /usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair
Have more questions? Submit a request
Please sign in to leave a comment.