Issue Plesk Onyx MariaDB Password Issue

[Mike Flanagan]

Hello,

After experiencing issues connecting to MariaDB via the command line using the admin password, I had to use mysqld_safe to reset the password.

The admin panel can now no longer connect to the database. Instead we experience the following issue:

ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69)

How can we reset the password globally? I have tried:

plesk bin admin --set-admin-password -passwd 'mynewpassword' -encrypted-password

But it won't work.

 

[Bitpalast]

There is a difference between the Plesk database password for the database user "admin@localhost" and the Plesk GUI login password for the Plesk user "admin". When you change the Plesk database password for admin@localhost, you need to enter the new password into the file /etc/psa/.psa.shadow . The "plesk bin admin" command does not touch that database password, it reconfigures the Plesk GUI user password of the "admin" user.