Plesk using outdated password for MYSQL5.7
Pointers for updating the Plesk MySQL password
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.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
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword
, which is whatplesk db
was trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quit
MYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword"
, quotes included.