Plesk using outdated password for MYSQL5.7

Pointers for updating the Plesk MySQL password

  1. According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > example.com > Databases > User Management > database_name and in the the new window submit the new password.

  2. Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run plesk sbin psadb -u --password="password" with the new password from command line.


Additional Resources & References

  • Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
  • The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
  • Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)

Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options

  1. Run mysql: mysql -u admin -p MyMySQLAdminPassword, which is what plesk db was trying to do with the credentials it knows.
  2. Paste the command UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
  3. quit MYSQL
  4. Run the command: plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.