Posted: May 14th, 2018
On Windows Server Plesk uses two MySQL instances:
Plesk SQL Server on the port 8306: for Plesk databases psa and apsc
MySQL server on the port 3306: for Horde, Sitebuilder and clients' databases
Accessing Plesk SQL Server
For Plesk Onyx and 12.5 use plesk utility:
> to access Plesk database:
Command Prompt:
plesk db
> to run a query in Plesk database:
Command Prompt:
plesk db "select * from <table>"
For Plesk 12.0, 11.x and below use the following command:
> to access Plesk database:
Command Prompt:
"%plesk_dir%\MySQL\bin\mysql" -P8306 -uadmin -p psa
> to run a query in the Plesk database:
Command Prompt:
"%plesk_bin%\dbclient" --direct-sql --sql="select * from <table>"
Accessing MySQL server
> Execute the following command:
Command Prompt:
"%plesk_dir%\MySQL\bin\mysql" -P3306 -uadmin -p
If the password is unknown, reset it