How to create Manually create a MySQL database in Cpanel

Please note that when using the Fantastico Feature, the database is created
automatically after the user imputs the required information available
in each script.

Step 1. Create your DB and User.

First, login to your CPanel account. If you don't have your username and password, you'll need to contact us.

Once you've logged in, select MySQL databases from the list. Keep in mind that your Cpanel account may be using a skin or different theme, so it will not always look exactly like the screenshot below.

MySql Screenshot

Step 2. Create your DB and User.
Type in a name for your new database name and click the "Add DB" button.
See screenshot below.

Database Name Screenshot.

Then, type in a Username and a Password into the relative fields and
click the "Add User" button.

Database Username-Password.

Step 3. Set Permissions and your finished.
Once your Database and User have been created, you need to give that user permission to use that database. We do this by selecting the username we created from the drop down and the database we created from the drop down, making sure the "All" checkbox is selected and clicking the "Add User to DB" option.

Database Permissions

The last thing you will need is the MySQL server hostname. If this hasn't been supplied you can get it from this screen in this location:

Database Server Name.

Note that the Username and Database will be prepended with your Cpanel login name.
For example, if you created a database called DB and your cpanel login was mysite then your new database will be mysite_db.

That's it. You're now ready to use the MySQL database that you just created.