Issue DB query failed: (1045) SQLSTATE[HY000] [1045]

[hsoheili]

While attempting to access the DB in the terminal in plesk, I was not sure on the admin login’s password so I changed the password, not noting it down (My bad).

I can not access plesk now because of that change.

How can this be resolved?

 

[Sebahat.hadzhi]

Hello, @hsoheili . What you can do is connect to the server via SSH as the root user and change the Plesk admin password with the following command:

plesk bin admin --set-admin-password -passwd 'your_new_password'

If you don't have root access yourself, please ask the server administrator/hosting provider to change the password for you.

 

[hsoheili]

Hello, @hsoheili . What you can do is connect to the server via SSH as the root user and change the Plesk admin password with the following command:

plesk bin admin --set-admin-password -passwd 'your_new_password'

If you don't have root access yourself, please ask the server administrator/hosting provider to change the password for you.

root@41DD089:~# plesk bin admin --set-admin-password -passwd 'XXXXXX'

DB query failed: (1045) SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

exit status 1
root@41DD089:~#




I will change the password again once i can get this process working correctly.

 

[scsa20]

To resolve your issue refer to https://support.plesk.com/hc/en-us/...d-for-user-admin-localhost-using-password-YES

It lists out 2 ways to fix it, one way is if you know the password to the admin account for the database and one if you do not know the password, so follow the steps depending on which one fits your needs.

 

[Tobias Sorensson]

you can try from the cli plesk login and then you get a secret link to get into plesk and try and change / update the password via the gui