2.14. MYSQL

CHAPTER 2. HOW DO I USE WEBHOST MANAGER?

Figure 2.91: Adding a MySQL access host

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

button.

Figure 2.92: 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

button.

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

71