Creating a MySQL Database

When installing a script that requires a MySQL database you aren’t told how to set up the database, and it isn’t terribly straight forward. This guide shows you what to click and in which order.

1. Login to the Website Control Panel and click “MySQL Databases”.

1. Choose a database username and password and click “Add User”. They can be anything you like but choosing a username similar to the script name will make it easier to identify in the future. For this example we’ve used “tut” and “tutpass”.

1. You will see this confirmation screen, click “Go Back”.

1. Enter the database name and click “Add DB”. The username and database name don’t have to be the same, but it’s easier to remember. For the example we’ve used “tut”.

1. You will see this confirmation screen, click “Go Back”.

1. Select the username and database you just created from the drop-down boxes. Make sure “All” is ticked unless your installation instructions state otherwise and click “Add User to Db”.

1. You will see this confirmation screen, click “Go Back”.

1. You are finished! Note that your Website Control Panel username is automatically prefixed to the username and database name so you must include that when configuring your script.

1. Here is an example script configuration: