Adding and Removing Database Servers

Adding External Database Servers to Plesk

To use external database servers with your hosting server:

1. Set up an external database server:

   1. Install MySQL, PostgreSQL, or Microsoft SQL software.

      For the supported versions, see Release
      Notes.

   2. Set up the database administrator’s account.

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

   • 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 > Add/Remove
     Components, unless it was installed with Plesk.

   • 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. 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 external
     database.

   • Specify which database type is running on the database server.

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

   • <p class="…