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

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

1. Log in to server using RDP.

2. Download MySQL/MariaDB service installer from the official site.

3. Run the MySQL/MariaDB installation file.

4. Press Add ... button.
   

5. Add MySQL/MariaDB server to the installation.
   

6. Proceed with the installation.
   

7. 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.

   

8. Specify MySQL/MariaDB Root Password.
   

9. Proceed with MySQL/MariaDB installation.

1. 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

2. Execute the command below in Command Prompt and open Windows Services:

   C:> services.msc

3. Make sure that there are two MySQL/MariaDB services running.
   

1. Log into Plesk.

2. Go to Tools & Settings > Database Servers > Add database server .

3. 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.