- Plesk for Windows
How to add an additional local MySQL server in Plesk on Windows?
Note: Instructions below are just an example assuming MySQL 5.7 is installed and configured in Plesk.
Note: additional information can be found in the official documentation.
Log in to server using RDP.
Download MySQL service installer from the official site.
Run the MySQL installation file.
Press Add ... button.
Add MySQL server to the installation.
Proceed with the installation.
Specify TCP/IP port different from
3306as it is used for MySQL server shipped with Plesk.
Warning: MySQL servers do not work at the same time if they use the same configuration file and the same port.
Specify MySQL Root Password.
Proceed with MySQL installation.
Make sure that port
3307is specified in
my.iniconfiguration file for the second MySQL server installed. Default file location is Use file located in
C:\ProgramData\MySQL\MySQL Server X.X\my.ini:
CONFIG_TEXT: port = 3307
Execute the command below in Command Prompt and open Windows Services:
Make sure that there are two MySQL services running.
Go to Tools & Settings > Database Servers > Add database server .
Select MySQL in Database server type , specify a Host name or IP address, Port number and Authentication data of another MySQL server.
Note: By default, Administrator's username for additional MySQL server is
Please sign in to leave a comment.