Linux – Plesk: access thesql as root


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?

Best Answer

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.

Related Topic