What is the root password for MySQL?

Created:

2016-11-16 12:45:00 UTC

Modified:

2017-04-29 17:17:25 UTC

19

Was this article helpful?


Have more questions?

Submit a request

What is the root password for MySQL?

Applicable to:

  • Plesk for Windows
  • Plesk for Linux
  • Plesk

Question

What is the root password for MySQL?

Answer

Plesk renames root MySQL account to admin when Plesk is installed.To get root privileges in MySQL simply login with the admin username instead. The password is the same as the admin password in Plesk .

On server with Plesk versions 8.x , 9.x and above admin password is stored in file /etc/psa/.psa.shadow . Use the following command to get the password:

# cat /etc/psa/.psa.shadow

Since Plesk 10 Plesk admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text:

Linux:

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

Windows:

"%plesk_bin%\\plesksrvclient" -get

Despite version of Plesk you may use the following command to login to mysql with root privileges:
Linux:

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

Windows:

"%plesk_dir%\\MySQL\\bin\\mysql" -P8306 -uadmin -p<password_from_the_previous_step> DATABASE_NAME
Have more questions? Submit a request
Please sign in to leave a comment.