78 Configuring and Maintaining Your Server
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.
