Managing Database Servers

To manage a database server:

  1. Go to Server > Database Servers.
  2. Click the icon corresponding to the database server you need. A web interface of a database management tool will open in a separate browser window.

To change the database server administrator's password:

  1. Go to Server > Database Servers.
  2. Click the host name of a database server.
  3. Click Change Password.
  4. Type the new password and click OK.

To unregister a database server from Plesk:

  1. Click the Server shortcut in the navigation pane.
  2. Click the Database Servers icon in the Services group.
  3. Select the check box to the right of the database server's host name.
  4. Click Remove Selected.
  5. Confirm the operation and click OK.

To unregister a database server that has databases or is assigned as default for hosting customers' databases from Plesk:

  1. Delete databases from the database server:
    1. Click the Server shortcut in the navigation pane.
    2. Click the Database Servers icon in the Services group.
    3. Click the host name of a database server that you wish to unregister from Plesk.
    4. Select the checkbox in the upper-right corner of the list to select all databases.
    5. Click Remove Selected.
    6. 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 the same database server type (MySQL or MS SQL) as the one you are going to delete.
    3. Click Preferences and Select the Use this server as default for MySQL check box. If you have a MS SQL database server, select the Use this server as default for PostgreSQL check box.
    4. Click OK.
  3. Return to the list of database servers (Server > Database Servers).
  4. Select a check box corresponding to the database server that you no longer need.
  5. Click Remove Selected.
  6. Confirm the operation and click OK.

Important: You cannot remove site applications' databases this way. To remove them, you should uninstall the respective site applications from the domains that use them.

For instructions on managing databases, refer to the Deploying Databases section of this guide.