How do I log into MySQL as the root user on my Plesk server?

Versions 10 and higher of Plesk have the administration password encrypted on the server. As a result, if you do not know the password, you cannot log into the MySQL database with administration powers.

However, you can get the administration password from a command line:

/usr/local/psa/bin/admin --show-password

And now that you know the password, you can log into MySQL with root administration privileges on any version of Plesk with this command line:

mysql -uadmin –p’cat /etc/psa/.psa.shadow’

This command gives you access to the MySQL database on the server.

Article ID: 31
Created On: Mon, Mar 2, 2015 at 5:20 PM
Last Updated On: Wed, Aug 18, 2021 at 2:16 PM

Online URL: https://www.heartinternet.uk/support/article/how-do-i-log-into-mysql-as-the-root-user-on-my-plesk-server.html