2.14. MYSQL

CHAPTER 2. HOW DO I USE WEBHOST MANAGER?

2.14.3

Setting up a remote MySQL server

You can change the MySQL server from the local server ( localhost ) to point to a remote server. This

allows MySQL functions to be performed by another computer.

To set up a remote MySQL server:

1. Click on the Setup Remote MySQL server link in the MySQL menu.

2. Enter the name of the remote server in the Remote Mysql Host field and its password in the Remote

Mysql Host's Root Password field.

Note: Do not enter the root password for the remote MySQL server in the Remote Mysql Host's

Root Password field.

3. Click on the Setup button.

Figure 2.93: Setting up a remote MySQL server

2.14.4

Repairing a database

You can attempt to repair a MySQL database using WebHost Manager. The function checks each table for

errors and attempts to fix them.

To repair a database:

1. Click on the Repair a Database link in the MySQL menu.

2. Click on the database that you want to repair in the displayed list and click on the Repair Database

button.

Figure 2.94: Repairing a database

3. A status list is displayed, stating which tables have been checked and the result.

2.14.5

Changing passwords

You can use WebHost Manager to change the password of any MySQL user or database on your server.

To change a user or database password:

71