HostOnNet Blog

Find MySQL root password in Plesk Server

Looking for Linux Server Admin or WordPress Expert? We can help.

Plesk MySQL server have no root user. Instead Plesk have user “admin” with root privileges.

mysql -u admin -p`cat /etc/psa/.psa.shadow`

To find password for user admin, run

[root@server22 ~]# cat /etc/psa/.psa.shadow
FfRBehWy
[root@server22 ~]#

To login to MySQL

mysql -u admin -pFfRBehWy

For example

[root@server22 ~]# mysql -u admin -pFfRBehWy
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2555 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

To login with out password, create a file /root/.my.cnf

vi /root/.my.cnf

With following content

[mysql]
user = admin
password = FfRBehWy

[mysqldump]
user = admin
password = FfRBehWy

This will allow you to use mysql and mysqldump with out providing passwords.

Posted in Web Server

3 Responses to Find MySQL root password in Plesk Server

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.