Take the 2-minute tour ×
Server Fault is a question and answer site for 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

closed as off-topic by HopelessN00b Jan 14 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.

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
    
This question appears to be off-topic because it is about working with a service provider's management interface, such as cPanel. –  HopelessN00b Jan 14 at 8:44

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

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