How to Create a MySQL Database in cPanel


Are you have a project on your local server? And want to upload it on the live server? Then you need to create the database on the server. This tutorial describes the process of creating database and tables on the server in cPanel.

how-to-create-mysql-database-in-cpanel-by-codexworld

We assumed that you already have cPanel enabled web hosting server. To add the database in cPanel, follow the step by step instructions given below.

1. Log into the cPanel with your cPanel username and password.

cpanel-login-by-codexworld

2. After login success, you would enter into the cPanel of your hosting account.

hosting-cpanel-account-by-codexworld

3. Click on the MySQL Databases link under the Databases section.

cpanel-mysql-databases-by-codexworld

4. Go to the MySQL Users section and add a new user with username and password.

cpanel-add-mysql-database-user-by-codexworld

5. Once the user is created successfully, click on Go Back link.

cpanel-mysql-database-user-created-by-codexworld

6. You’ll see the newly created user has listed under the Current Users section.

cpanel-database-current-users-by-codexworld

7. Enter the database name and create a database from the Create a New Database section.

cpanel-create-database-by-codexworld

8. Once the database is created successfully, click on Go Back link.

cpanel-added-mysql-database-by-codexworld

9. You’ll see the newly created database has listed under the Current Databases section.

cpanel-current-databases-by-codexworld

10. Go to the Add a User to a Database section. Select the newly created user as User and Select the newly created database as Database. Click on Add link.

cpanel-add-user-to-database-by-codexworld

11. Check the ALL PRIVILEGES checkbox and click on Make Changes button.

cpanel-database-user-privileges-by-codexworld

12. Go to the cPanel home by clicking on the Home icon on the top.

cpanel-home-by-codexworld

13. Click on the phpMyAdmin link under the Databases section.

cpanel-database-phpmyadmin-by-codexworld

14. You’ll be entered into the phpMyAdmin panel. Click on the database name from the left sidebar and create tables into the database as per your project needs.

cpanel-create-tables-into-the-database-by-codexworld

Leave a reply

Connect With CodexWorld