MySQL:

Creating a database

If your package allows for the creation of a database it is an easy process to add one. Click 'MySQL databases' in your web panel home page, enter the desired name, click add database, add the username and password and it is ready to use.

To add a user to a database click on the 'MySQL databases' in your web panel home page, enter the user's name in the UserName field and the user's password in the Password field. Click on the Add User button.

Once you have created a user to use a database you need to grant that user permission to use the database. To grant user permissions to a MySQL database:

1. Click on the MySQL databases button on the home page.
2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
3. Click on the Add User to Db button.

The user now has permission to use that database and sample connection strings are shown in the MySQL window.

About phpMyAdmin

Connection Problems

Backing up a database

Common Problems

Remote access to a database

You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. localhost stands for your own web server.

To add host access:

1. Click on the MySQL databases button on the home page.
2. Enter the domain name or IP number of the host that you wish to add in the Host field.
3. Click on the Add Host button.