How can I login to MySQL on Linux Plesk?

The following error appears while trying to login to MySQL at the prompt on Plesk from root user:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

This is because Plesk doesn't allow root user to login to MySQL. Use admin user instead. Plesk stores the admin password in /etc/psa/.psa.shadow file. You can supply the admin password while connecting or pass the password directly as:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

VZPP shows MySQL and httpd down?

If you have cPanel, this is due to incompatiblity between the VPS system and cPanel. The VPS...

What name servers do I use for my domains on my VPS?

Please register your private name servers using the tutorial that applies to your domain...

I would like to change the OS (operating system) of my VPS. How can I do that?

If you would like to change the OS of your VPS, you need to take a complete backup of any of your...

Which Linux flavor do you recommend for my VPS and why?

We recommend enterprise level operating systems such as CentOS. This is because it has the most...

I have a shared/reseller account. Why should I upgrade to VPS?

VPS is a virtual private server that gives you a separate process environment not shared by other...