1. Click on MySQL Databases in the cPanel Dashboard.
This section allows you to create and manage databases for your website.
You can also manage database users, permissions, and database connections here.

2. Now Create your Database with User.
A database is required to store website content, settings, and user information.
Make sure to create both the database and database user carefully.

3. Enter the Database Name.
Type a unique and easy-to-identify database name for your website.
Click on the Create Database button to complete the database creation process.

4. Enter the Database Username.
Create a secure username that will be used to access the database.
Always use a strong password to improve database security

5. Add User to the Database.
Select the database user and connect it with the created database.
Grant all required privileges so the website can read and write data properly.

6. Login to your cPanel and click on PhpMyAdmin.
PhpMyAdmin is a web-based tool used to manage MySQL databases easily.
You can import, export, edit, and manage database tables from this section.

7. Find the 'Import' option in PhpMyAdmin and upload your SQL File.
Click on the Import tab and select the SQL backup file from your computer.
After selecting the file, click on the Go button to start the database import process.

Note: After uploading the website files and SQL file, the customer must connect the database to the website files with the help of a web developer.
The database credentials such as database name, username, password, and hostname must be updated correctly in the website configuration file.
Still need help?
Our support team is available 24/7 to assist you with any hosting questions.
Contact Support