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.

    image-Database-Servers

  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 and Upgrades > 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 internal 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.

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

  5. Click OK.

If you have registered a SQL Server, you may want to provide its backup settings. For configuring the backup settings of a remote SQL Server, refer to Configuring Backup Settings for Remote SQL Servers.

Removing Database Servers from Plesk

You can remove a database server only if it is not the default server and there are no databases on it.

To unregister a database server from Plesk:

  1. Go to Tools & Settings > Database Servers.
  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 unregister a database server that has databases or is assigned as default for hosting customers’ databases:

  1. Delete databases from the database server:
    1. Go to Tools & Settings > Database Servers.
    2. Click the host name of the database server that you wish to unregister from Plesk.
    3. Select the checkbox in the upper left corner of the list to select all databases.
    4. Click Remove.
    5. Confirm removal and click OK.
  2. Make another database server default:
    1. Click the Database servers shortcut in the path bar at the top of the screen.
    2. Click the host name of a database server that you wish to make default. This should be of the same database server type (MySQL or SQL Server) as the one you are going to delete.
    3. 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.
    4. 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.

Note

You cannot remove databases used by web applications this way. To remove them, you should first remove the respective web applications from the sites that use them.