Client Login

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`



Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article
Also Read
I have a shared/SDX/reseller account. Why should I upgrade to VPS? (Views: 4095)
Can you transfer my sites from my current host to my new VPS? (Views: 4480)
Can I install JRE/JDK/Java on my VPS? (Views: 4560)
Which control panel should I choose and which one is better? (Views: 4615)
VZPP shows MySQL and httpd down? (Views: 4562)