Posts

Showing posts from July, 2016

Forgot Mysql Password - PLESK WINDOWS - Root not Logging In

What is the root password for MySQL? Article ID: 427, created on Oct 6, 2008, last review on Jun 3, 2016 Applies to:Plesk for Linux/UnixPlesk for Windows Question What is the root password for MySQL? AnswerPlesk renames rootMySQL 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.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: