Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
2  
Don't use Plesk. Or PHP, if you can help it. You'll feel much better. –  Tom O'Connor Jan 28 '13 at 17:09
1  
I completely agree on the Plesk, but I'm stuck with it, and I would love to learn something other than PHP. If only time permitted me to. –  SLD Jan 28 '13 at 19:09

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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