How to Add or Remove a Remote Database Server in Plesk?

1. Log in to Plesk.

2. Go to Tools & Settings > Database Servers (under “Applications & Databases”), and then click Add Database Server.

   

3. Specify the properties of the database server:

   • Specify the database server engine in the Database server type box. The list contains database engines supported by your licence key. You can check what components are supported on the Tools & Settings > Licence Management page.

     Note: To use Microsoft SQL Server with Plesk, you need to obtain Plesk Power Pack.

   • Specify the hostname or IP address of the database server.

   • Specify the port number the database server is listening on. This option is available only for MySQL/MariaDB. By default, MySQL/MariaDB servers listen on port 3306. You can leave the Port number box blank, if your MySQL/MariaDB database server is listening on the default port.

     Note: Do not enter the value for MySQL/MariaDB server port equal to 8306, because it is used by Plesk for communication with its internal database.

   • To make this database server default for hosting customers’ databases, select the “Use this server as default for MySQL” or the “Use this server as default for MS SQL” checkbox.

   • Specify the database server administrator’s login and password.

4. Click OK.

To remove a database server from Plesk:

1. Go to Tools & Settings > Database Servers (under “Applications & Databases”).
2. Select the checkbox to the right of the database server’s host name.
3. Click Remove.
4. Confirm the operation and click OK.

To remove a database server that has databases or is assigned as default for hosting customers’ databases:

1. Delete databases from the database server:
   • Go to Tools & Settings > Database Servers (under “Applications & Databases”).
   • Click the host name of the database server that you want to remove from Plesk.
   • Select the checkbox in the upper left corner of the list to select all databases.
   • Click Remove.
   • Confirm removal and click OK.
2. Make another database server default:
   • Click the Database servers shortcut in the path bar at the top of the screen.
   • Click the host name of a database server that you wish to make default. This should be of the same database server type (MySQL/MariaDB or SQL Server) as the one you are going to delete.
   • Click Preferences and select the Use this server as default for MySQL checkbox. If you have a SQL Server, select the Use this server as default for MS SQL checkbox.
   • Click OK.
3. Return to the list of database servers (Tools & Settings > Database Servers).
4. Select a checkbox corresponding to the database server that you no longer need.
5. Click Remove.
6. Confirm the operation and click OK.