Previous Topic

Next Topic

Book Contents

Managing Database Servers

To manage a database server:

  1. Click the Server shortcut in the navigation pane.
  2. Click the Database Servers icon in the Services group.
  3. 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 MySQL database server administrator's password:

  1. Login to the MySQL database server as root.
  2. Login to MySQL as root.
  3. Issue the command at the prompt:

    mysql> SET PASSWORD for ROOT = PASSWORD('new_password');

    Where root is the user account, and new_password is the new administrator's password.

  4. Log in to your Plesk control panel.
  5. Click the Server shortcut in the navigation pane.
  6. Click the Database Servers icon in the Services group.
  7. Click the database server's name.
  8. Type the new administrator's password and click OK.

To change the PostgreSQL database server administrator's password:

  1. Login to the PostgreSQL database server as root.
  2. Login to PostgreSQL as root.
  3. Issue the command at the prompt:

    ALTER USER root WITH PASSWORD 'new_password';

  4. Log in to your Plesk control panel.
  5. Click the Server shortcut in the navigation pane.
  6. Click the Database Servers icon in the Services group.
  7. Click the database server's name.
  8. Type the new administrator's 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 name.
  4. Click Remove Selected.
  5. Confirm the operation and click OK.

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

  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. Click the Databases tab.
    5. Select the checkbox in the upper-right corner of the list to select all databases.
    6. Click Remove Selected.
    7. 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 PostgreSQL) as the one you are going to delete.
    3. Select the check box labeled Use this server as default for MySQL. If you have a PostgreSQL database server, select the check box labeled Use this server as default for PostgreSQL.
    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.