- Plesk Onyx for Windows
How to add an additional local MySQL server in Plesk on Windows?
Warning: Plesk may become temporary unavailable during applying the steps from the article. Consider implementing the solution during the maintenance timeframe.
Warning: MySQL services have to use different configuration
Log in to server using RDP.
my.inifile to use another port, e.g. 3307. Use file located in
C:\Program Files (x86)\Plesk\Databases\MySQL\my.inias an example.
port = 3307
Warning: if Web Presence Builder is installed configure port in the config file as well in
CONFIG_TEXT: port = 3307
Go to Control Panel > Administrative Tools > Services and Stop and Start MySQL service.
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.
Warning: MySQL servers may not work at the same time if they use the same configuration file and the same port.