In windows plesk there are two instances of MySQL running. One is listening on port 8306 used by plesk and other running on regular 3306 which stores the clients database. Now to retrieve the MySQL admin password of user mysql. Follow the below steps. Open command promt and run the below commands
[shell]
cd %plesk_dir%\mysql\bin
mysql -P 8306 -u admin -pPLESK_PASSWORD psa
select * from databaseservers;
[/shell]
The select command will show you the list of database servers added to plesk along with it’s admin/root username and password.
Leave a Reply