Error establishing a database connection after wordpress database user password was changed via Plesk

Refers to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:23:42 UTC

Modified:

2016-12-21 20:37:11 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error establishing a database connection after wordpress database user password was changed via Plesk

Symptoms

  1. When changing Wordpress (WP) database password via Plesk GUI at: Home > Subscriptions > example.com > Websites & Domains > WordPress Installations > My CMS > "Change Settings"

to one that does not meet Plesk security policy, the following error appears:

    Error: Unable to update the WordPress installation settings: Your password is not complex enough. According to the server policy, the minimal password strength is Medium. To improve the password strength, use numbers, upper and lower-case characters, and special characters like !,@,#,$,%,^,&,*,?,_,~

Then it becomes impossible to login to WP admin console from Plesk:

    Error establishing a database connection
  1. When changing Wordpress (WP) database password and login via Plesk GUI at: Home > Subscriptions > example.com > Websites & Domains > WordPress Installations > My CMS > "Change Settings"

to one that does not meet Plesk security policy, the following error appears:

    Error: Unable to update the WordPress installation settings: Your password is not complex enough. According to the server policy, the minimal password strength is Medium. To improve the password strength, use numbers, upper and lower-case characters, and special characters like !,@,#,$,%,^,&,*,?,_,~

Further attempt to change database password/username or login via Plesk GUI fails with error:

    Error: Unable to update the WordPress installation settings: Non-zero exit status returned by script. Output stream: 'PHP Warning: mysql_connect(): Access denied for user 'user'@'localhost' (using password: YES) in /usr/local/psa/var/apspackages/apscatalog6KI24i.zip63ac5532-7919-0a/cache/scripts/db-util.php on line 66 '. Error stream: 'PHP Warning: mysql_connect(): Access denied for user 'olduser'@'localhost' (using password: YES) in /usr/local/psa/var/apspackages/apscatalog6KI24i.zip63ac5532-7919-0a/cache/scripts/db-util.php on line 66 '.

Then, attempt to set database user name specified previously as "Database user name" fails with error:

    Error: Unable to update the WordPress installation settings: User with requested name already exists

Cause

  1. The password was changed in mysql.user table for the WP user but was not in wp-config.php .

  2. The password and WP database user name were changed in mysql.user but was not in psa.db_users and wp-config.php .

Such behaviour is known as software issue #PPPM-2322 .

Resolution

The issue is fixed in Plesk 12.0.18 MU #28 . To fix the issue install latest microupdates # 213943585 and update password again via Plesk GUI at:

Home > Subscriptions > example.com > Websites & Domains > WordPress Installations > My CMS > Change Settings

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