Steps to create database and add file content

• cPanel username: atestvwk
• MySQL Database: atestvwk_dbname

Creating a database using MySQL database
 

1. Log into your cPanel account.
2. Click on the MySQL Databases menu in the Databases section.

3. Enter the database name you want on the New Database field and click the Create Database button.

4. Click the Go Back button

Creating a database using MySQL Database Wizard

1. Log into your cPanel account.
2. Click on the MySQL Databases Wizard menu in the Databases section.

3. Enter the database name you want on the New Database field and then click the Next Step button.

4. Enter a username Next to the Username field.
5. Enter a password next to the Password field, reenter the Password and then click on the Create User button.

6. Now you can assign rights for the user to the database. Check the box next to All Privileges and then click on Next Step button.

7. Once done, you will get a confirmation that the MySQL User was successfully added to the MySQL Database.

Steps to import MySQL databases

1. Log into your cPanel account.
2. Click on phpMyAdmin in the Databases section on the cPanel home screen. You will now be redirected to the phpMyAdmin interface.

3. On the left, click on the database that you will be working with.

4. Click on the Import tab.

5. Click on the Choose File button and select the compressed SQL file.
6. Ensure SQL is chosen as the format.
7. Click Go.