Knowledgebase

How to create a MySQL database

MySQL Databases allow you to store lots of information in an easy to access manner. This tutorial will assume that you are already logged into your cPanel. If you are having problems doing that or don't know how, please view the tutorial named: How to log into cPanel.

On your cPanel main page scroll down to the database section and click on the MySQL databases link to load the MySQL databases main page. There is a box below the heading Create New Database, type the name of your new database into this box. For example, something like myinfo or mydata then click on create database button which will load a verification screen showing that the database has been created. Now you need to create and add a user to this database. Click the go back link.

Under the heading of Add New User, enter a new user to be added to your database in the username box then enter and re-enter a password for the user. Click on the Create User button which takes you to a screen to confirm that the user has been successfully created. Now you need to link the user to the database. Click on the go back link.

In the section where it says add user to database, check to make sure that the correct user and the correct database are selected here.

Note: You will see that the username of the hosting account has been added to the beginning of both the user and the database with an "_" underscore between them. If the user and database are both correct, click on submit to add the user to the database.

This will take you to a screen called Manage User Privileges. You can assign all privileges to the user by checking the top box then click make changes to load the final verification screen that will confirm all the information.

You can return to setup more databases,(as allowed by your hosting plan) add or remove users or delete databases at any time.

You can now click the home link in the upper left corner and return to the main cPanel page or to exit cPanel use the logout link in the upper right corner. Remember, if you are using a public computer, ALWAYS logout of cPanel before closing.

For additional assistance, contact us by submitting a support ticket.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Quick Navigation
Language:

Client Login:

Email

Password

Remember Me