Create MySQL database in cPanel

Creating a MySQL database in cPanel is a three step process

1. Creating an empty database as well as creating an username and a password
2. Linking the user to the database
3. Using phpMyAdmin to add tables or update from a SQL backup

Creating the database and user in MySQL:

1. Log into your cPanel (like www.yourdomainname.com/cpanel)
2. Click on MySQL Database icon on the cPanel home page
3. In Create New Database, enter the database name and click the Create Database button. Once created, click on back link to return to the MySQL Database page
4. Go to MySQL Users in the same page and enter a username. Click on Generate Password to create a password for the username. Finally, click on Create User button. Once created, click on the back link to return to the main MySQL Database page
5. Now the database and a user are created. Now we have to link both of them. So go to Add User to Database. Select the user and database that you have created from the drop-down menus. Click on Add button. If you are asked for Privileges, select All Privileges and click on Make Changes button. After getting the confirmation message, click on the back link to go back and go to the cPanel home page

Creating tables and updating data using phpMyAdmin:

1. Go to the Databases section in cPanel home page and click on the phpMyAdmin icon
2. A new browser window will open with the phpMyAdmin home page. Click on the database from the left frame. This should change the content in the right frame
3. In the right frame, you can follow the intuitive forms to create a table
4. If you have a SQL backup, click on SQL tab in the right frame
5. In the Run SQL Query window, paste the entire content of your SQL backup file and click on the Go button. This should update the database with the tables and data.

Remember to change the values in the database connection script – update the database host, username, password and the database name.