Cpanel: How create new database

First: Log in your Cpanel

Second: Click on MySQL Databases as the following image shows



Third: you will see page that looks like the following



Here is a quick description of the options on this page

  1. Current Databases: type the name of the database then click on Create Database
          Note: database can be any thing you wish as long as it is not already exists! (ex. articles)
          Importent: you database will be created as the following (ex. username_articles) where article is what you created and username is your student username.
  2. Current Users:type any username you wish to create for the database access and the password the click onCreate User
          Note: username can be any thing you wish as long as it is not already exists! (ex. malhayek)
          Importent: your user name will be created as the following (ex. username_malhayek) where malhayek is what you created and username is your student username.
  3. Add Users To Your Databases: this option is to assign a username to a database. Simply by selecting a username from the drop down menu A and database from the drop down menu B
          Note: username is a name you created after using option 2 . database is a name you created after using option 1
          Importent: this option is the most importent step of creating your database and assigning its privileges.
  4. Access Host: this option is to assign hosts that you want them to access your databases from a different server.You can do that simply by entering the away server and click Add Host.
  5. phpMyAdmin: this option allows you to manage all you databases by adding/updates your tables.



Fourth: create a new database name

Fifth: create a new username for the database

Sixth: Assign a username to a database and set its privileges. by defult ALL is selected

Finally, if you completed all the previous steps you have created a established a new database!!!


To make sure that you have successfully created the database

you can check by clicking on phpMyAdmin: which is the very last option. A page should open in a new window that looks some whats like the following.



on the very left hand side you will see a list of all your database!!! This example shows that there is only one database with the name DBname as you notice it is created as username_databasename where here it is malhayek_DBname "malhayek" is the student username and "DBname" is the database name that you have created!!
Also, the number that is next to the database name is the total of contained tables.