Create Database using cPanel

Create a Database

How to create Database using cPanel

Database is an essential part in any modern website system. Any Content Management System like WordPress or Joomla needs a Database. Ecommerce Management Systems like Magento, Opencart, Prestashop, Zencart, osCommerce, Cubecart need a database for proper functioning of the website. Whenever we talk about Database never forget to backup your databases on a regular basis. In this article, we will go through two methods by which to create a database in cPanel. The process is almost the same for any other hosting software.
 
Things we need – Keep the following things handy

  1. Database Name
  2. Database UserName and Password
  3. Database UserName Privileges (rights)

After you have got your suitable hosting plan you can log into your Just IT Hosting – My Account.


On the top right hand side under your Account name click on My Products. In the Web Hosting section look for your hosting account and click on Manage.
 

Fig 01 : How to Create a Database using cPanel
Fig 01 : How to Create a Database using cPanel

In the next screen click on the cPanel admin button this will take you directly to your cPanel hosting control panel 

Fig 02 : How to Create a Database using cPanel
Fig 02 : How to Create a Database using cPanel

Moving forward there are two methods by which you can create your Database using the cPanel. One is the Wizard method and the other is the Step-by-Step method

Create Database using Step by Step method

In the cPanel Home window, under Databases, click on MySQL Databases.
 

Fig 03 : How to Create a Database using cPanel
Fig 03 : How to Create a Database using cPanel

Under Create New Database, in the ‘MySQL Databases’ window enter a suitable name for your Database and click Create Database.
 

Fig 04 : How to Create a Database using cPanel
Fig 04 : How to Create a Database using cPanel

click Go Back
 
You will be returned back to the ‘MySQL Databases’ window again. In this window, under MySQL Users – Add New User enter a suitable Username and a password for your Database and click Create User.
 
 

Fig 05 : How to Create a Database using cPanel
Fig 05 : How to Create a Database using cPanel

click Go Back
 
Back in the ‘MySQL Databases’ window again, under Add User to Database, select the User you just created and the name of the Database you want this user to manage and click Add
 

Fig 06 : How to Create a Database using cPanel
Fig 06 : How to Create a Database using cPanel

In the ‘Manage User Privileges’ section, click All Privileges to assign all database management rights to this user. Alternately, for security purposes, you can assign minimum privileges like Create, Insert, Update, Select and Delete just enough to manage your database.
 

Fig 07 : How to Create a Database using cPanel
Fig 07 : How to Create a Database using cPanel

Create Database using the Wizard method

This is a much simpler method :
In the cPanel Home window, under Databases, click on MySQL Database Wizard.
 

Fig 08 : How to Create a Database using cPanel
Fig 08 : How to Create a Database using cPanel

Under ‘Create a Database’ in the ‘MySQL Database wizaed’, enter a suitable name for your Database and click ‘Next Step’.
 

Fig 09 : How to Create a Database using cPanel
Fig 09 : How to Create a Database using cPanel

In the following screen, enter a suitable UserName and a password for your Database and click Create User.
 

Fig 10 : How to Create a Database using cPanel
Fig 10 : How to Create a Database using cPanel

Click ‘All Privileges’ to assign all database management rights to this user in ‘Add User to Database’ section. Alternately, for security purposes, you can assign minimum privileges like Create, Insert, Update, Select, Delete just enough to manage your database.
 

Fig 11 : How to Create a Database using cPanel
Fig 11 : How to Create a Database using cPanel

The Database has now been created, click on Return Home to go back to the cPanel Home window.
 

Fig 12 : How to Create a Database using cPanel
Fig 12 : How to Create a Database using cPanel

Where do we see the Database?

Now that we have created our Database, where do we see the Database we just created ?
 
In the cPanel Home window, under Databases, click on MySQL Databases (same as in Fig 03 in Step by Step method).
 

Fig 13 : How to Create a Database using cPanel
Fig 13 : How to Create a Database using cPanel

Click on phpMyAdmin listed in the Databases section in the cPanel Home window.
 

Fig 14 : How to Create a Database using cPanel
Fig 14 : How to Create a Database using cPanel

In the phpMyAdmin click on the Databases tab at the top and here you can see the list of all the Databases that you have created.
 

Fig 15 : How to Create a Database using cPanel
Fig 15 : How to Create a Database using cPanel

Please follow our Blog on Feedly for all the latest information. If you need more help, please call our Support Department at (480) 624-2500. We are available 24/7. You can also use our Email support system for any queries. Just IT Hosting 

Share it with your Friends

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.