Plesk MySQL root password

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

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.

This entry was posted in Plesk and tagged , , . Bookmark the permalink.

3 Responses to Plesk MySQL root password

  1. sathish says:

    Thanks! But I couldn’t find out the /root/.my.cnf file

  2. Chris says:

    Don’t forget to chmod 600 /root/.my.cnf

  3. admin says:

    Plesk servers don’t have /root/.my.cnf, you have to create your own if you want to login with out password.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>