Accessing the Database: Go to CPanel and Find the MySQL Databases Link.
Creating a Database: To create your database you need to fill up the text box with the label New Database and click the command button [Create Database].
Creating a User: To create a user you have to fill up the user name and password on the text boxes below. After filling it up you just need to click the command button [Create User].
Linking the User to the Database: You have to select what privileges you want to give to the user you created. Clicking the check box [ALL] will give a user all the privileges. In the User combo box you need to select which user you want to give a link to the database and with the Database combo box you have to select what database name to link the user. Next step is to click the command button [Add User To Database].
Accessing phpMyAdmin: To access phpMyAdmin you just need to select the phpMyAdmin link.
Importing the Database
Select the Database: To select the database you have to click the database you created. Usually the selection of database is at the left column.
Clicking the Import Tab: To access the Import module you just need to click the tab [Import].
Selecting the database dump: To select the database dump you just need to click the command button [Browse] to browse your local folder. The character set of the file default is utf8. Most sql dump uses this type of character set.
Process the Import: To process the importing your last step is to click the command button [Go].
Congratulations You’re done importing the database dump!