Article ID: 427, created on Oct 6, 2008, last review on Jun 3, 2016

  • Applies to:
  • Plesk for Linux/Unix
  • Plesk for Windows

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 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

Search Words

password root mysql

root password for MySQL

56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 85a92ca67f2200d36506862eaa6ed6b8

Email subscription for changes to this article
Save as PDF