Knowledge Base

How to add an additional local MySQL/MariaDB server in Plesk on Windows?

Note: Instructions below are just an example assuming MySQL 5.7 is installed and configured in Plesk.

1. MySQL/MariaDB server installation

Note: additional information can be found in the official documentation.

Log in to server using RDP.
Download MySQL/MariaDB service installer from the official site.
Run the MySQL/MariaDB installation file.
Press Add ... button.
Add MySQL/MariaDB server to the installation.
Proceed with the installation.
Specify TCP/IP port different from 3306 as it is used for MySQL/MariaDB server shipped with Plesk.

Warning: MySQL/MariaDB servers do not work at the same time if they use the same configuration file and the same port.
Specify MySQL/MariaDB Root Password.
Proceed with MySQL/MariaDB installation.

2. Verification of MySQL/MariaDB configuration

Make sure that port 3307 is specified in my.ini configuration file for the second MySQL/MariaDB server installed. Default file location is Use file located in C:ProgramDataMySQLMySQL Server X.Xmy.ini:

port = 3307
Execute the command below in Command Prompt and open Windows Services:

C:> services.msc
Make sure that there are two MySQL/MariaDB services running.

3. Registration of the MySQL/MariaDB server in Plesk

Log into Plesk.
Go to Tools & Settings > Database Servers > Add database server .
Select MySQL/MariaDB 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/MariaDB server is root.