English (US) 日本語
Submit a request

Technical question Licensing question
Sign in

How to manage a database hosted in Plesk using a local database client?
Plesk Update fails: NOKEY Importing GPG key 0xC74CD1D8
Database Servers page redirects to Plesk main page: Dependent row(s) isn't found
Are there any alternatives to myLittleAdmin in Plesk for Windows?
Unable to create domain: A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
MariaDB cannot start on Plesk server: redo log file exists
Unable to start MariaDB 10.6 on a Plesk server: Bind on TCP/IP port. Got error: 22: Invalid argument
Plesk or system update fails on Linux: http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Plesk database servers menu shows warning: Unable to determine the TCP port number used by Microsoft SQL server 'localhost'
MySQL package fails to update on Plesk server: The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.

See more

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

Renan Moreira

Updated March 01, 2023 11:40

Plesk for Windows kb: how-to ABT: Group B

Applicable to:

Plesk for Windows

Question

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

Answer

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

1. MySQL server installation

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

2. Verification of MySQL configuration

Make sure that port 3307 is specified in my.ini configuration 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:

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

3. Registration of the MySQL server in Plesk

Log into Plesk.
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 root.

Additional information

Starting Multiple MySQL Instances as Windows Services

Comments

4 comments

Adrian Chan September 08, 2020 09:38

Is this applicable for Plesk Obsidian Linux?

-1

Comment actions Permalink
Ivan Postnikov September 14, 2020 10:33

Hello Adrian Chan

This instruction is applicable for Windows servers only.

For Linux, we have corresponding suggestions.

Your goal may be achieved using Docker image:

https://www.plesk.com/blog/product-technology/plesk-docker-extension/

https://kb.virtubox.net/knowledgebase/how-to-run-mariadb-10-3-plesk-onyx-with-docker/

0

Comment actions Permalink
Adrian Chan September 15, 2020 10:26

Hi Ivan,

Thanks!

I managed to get MySQL ver 5.6.32 installed in Win 10.

I wanted to know if there is issues if I were to install MariaDB ver 10.4 on it as well?

Must the ports be different?

Thanks

0

Comment actions Permalink
Ivan Postnikov September 15, 2020 13:16

Hello Adrian Chan

Mind you, Plesk supports server versions of Windows only.

> Must the ports be different?

Different ports are to be used in case you want both servers to be running at the same time.

0

Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request