Forgot Mysql Password - PLESK WINDOWS - Root not Logging In

Article ID: 427, created on Oct 6, 2008, last review on Jun 3, 2016
  • Applies to:
  • Plesk for Linux/Unix
  • Plesk for Windows


What is the root password for MySQL?


Plesk renames root MySQL account to admin when Plesk is installed. To get root privileges in MySQL simply login with theadmin username instead. The password is the same as the admin password in Plesk.
On server with Plesk versions 8.x9.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:
# /usr/local/psa/bin/admin --show-password
"%plesk_bin%\plesksrvclient" -get  
Despite version of Plesk you may use the following command to login to mysql with root privileges:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin
"%plesk_dir%\MySQL\bin\mysql" -P8306 -uadmin -p<password_from_the_previous_step> DATABASE_NAME

Popular posts from this blog

How to Delete WHM Mail Queue through SSH sent from a particular sender

how to change witribe wlan password? how to secure your witribe router

SOLVED: WHM/CPANEL Your server does not support the connection encryption type you have specified. Try changing the encryption method