1

I cannot access MySQL as root on my Plesk 10.x + (Linux) VPS. Apparently Plesk disables the root account and replaces it with admin with the same password as your Plesk login, but access is still denied!

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

How can I get CLI access to MySQL if Plesk seemingly disables root access?

Improve this question
3

2 Answers 2

Reset to default
4

Almost correct.

Plesk actually uses the hash of your admin password as the plain MySQL password.

Obtain the hash by running cat /etc/psa/.psa.shadow - the full string of resulting gibberish is your plaintext MySQL password.

Improve this answer
4

For Plesk 10.x, try the following command to gain aaccess to mysql

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

For more information, check the following link - http://kb.parallels.com/en/427

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.