How to login as root (admin) user in the MySQL CLI with Plesk

Someone that has worked with the MySQL CLI knows how easy it is to access all databases on the server with the following command:

mysql -u root -p password

However, trying to do the same on plesk will fail basically because you will probably don't know what's the password to access MySQL. In this article we'll show you how to login as root/admin.

Logging in as admin in MySQL with Plesk

To login as admin (or root) to MySQL through the CLI in a server with Plesk you can use the following command:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin

What we are basically doing is to access as admin, the user that has all privileges to execute any query that you need with the encrypted password stored in the .psa.shadow file of Plesk. For more information about how to access to the MySQL CLI in Plesk, check the official article of Plesk here.

Happy coding !