0

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?

closed as off-topic by HopelessN00b Jan 14 '15 at 8:44

  • This question does not appear to be about server, networking, or related infrastructure administration within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

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.

3

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

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