How to login to psa database by setting admin password literally?

Created:

2016-11-16 12:50:56 UTC

Modified:

2017-04-24 12:09:50 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to login to psa database by setting admin password literally?

Applicable to:

  • Plesk for Linux

Symptoms

It is impossible to log in to database by using Plesk admin password literally:

# mysql -uadmin -p"admin_plain_password" psa
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Login with cat works with no issues:

#mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql>

How to login to database by setting admin password literally?

Resolution

Plesk admin's password is stored in /etc/psa/.psa.shadow in encrypted state for secure reason.

To use admin's password without using cat use the encrypted string from the file /etc/psa/.psa.shadow but make sure to screen the system symbols with "\":

# mysql -uadmin -p"\\$AES-128-CBC\\$==\\$tfwf7sqps2DHllv03wmY9A==" psa
mysql>

NOTE: To set or retrieve Plesk admin password use KB # 213381869

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