- Plesk for Linux
- Plesk for Windows
What is the root password for MySQL in Plesk?
Plesk renames root MySQL account to admin when Plesk is installed.
Since Plesk 12.5, it is possible to access MySQL console using the following command. By default, it connects to
database (you should be connected to the server using
# plesk db
Alternatively, in Linux it is possible to connect to MySQL using the following command:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
In Windows, it is possible to obtain admin password only by resetting it. To do so, it is required:
Connect to the server via RDP ;
Stop PleskSQLServer in Task Manager:
Edit the file
%plesk_dir%MySQL\my.iniand add the line
skip-grant-tablesas follows and save the file:
Start PleskSQLServer in Task Manager;
Connect to PleskSQLServer:
C:\> "%plesk_dir%\MySQL\bin\mysql" -P8306 -uadmin
Set the new password:
MYSQL_WIN: SET PASSWORD FOR 'admin'@'localhost' = PASSWORD('MyNewPass');
where MyNewPass is the new password for user admin .
Do not forget to revert the changes by deleting
from the file and restart PleskSQLServer to apply the changes.