Adding External Database Servers to Plesk

1. Set up an external database server:
     a. Install MySQL, PostgreSQL, or Microsoft SQL software.
     b. Set up the database administrator's account.
     c. Enable network access to the database server.
2. Log in to Plesk.
3. Go to Tools & Settings > Database Servers, and click Add Database Server.
4. Specify the properties of the database server:
     a. Specify a 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.

Note that before using a database server engine you should install it in Tools & Settings > Updates and Upgrades > Add/Remove Components, unless it was installed with Plesk.


     b. Specify the hostname or IP address of the database server.
     c. Specify the port number the database server is listening on. This option is available only for MySQL. By default, MySQL servers listen on port 3306. You can leave the Port number box blank, if your MySQL database server is listening on the default port.

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

     d. Specify which database type is running on the database server.
     e. To make this database server default for hosting customers’ databases, select the Use this server as default for MySQL checkbox. If you have a MS SQL database server, select the checkbox Use this server as default for MS SQL.
     f. Specify the database server administrator's login name and password.
5. Click OK.

If you want to teach that removing the database server from Plesk, you can visit this article.

Was this answer helpful? 0 Users Found This Useful (1 Votes)