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.