How to Create new Database – Database user in cPanel

Step by step Instructions with images for “How to Create new Database – Database user in cPanel”.
First, login to your CPanel account. If you don’t have your username and password, you’ll need to contact your web hosting provider.

How to Create new Database - Database user in cPanel - steptoinstall

Step 1: Go to MySQL Database Wizard

In cPanel, select MySQL Database Wizard from the Databases section.
How to Create new Database &Database user in cPanel - Go to MySQL Dtabase Wizard - steptoinstall

Step 2: Enter Database Name

Enter a name for new database as your wish and continue to the next step.

Example
Database name: sample
How to Create new Database - Database user in cPanel - Enter Database Name - steptoinstall

Red hidden mark showing the Database pre-extension. It’s depend upon cPanel user name. It’ll automatically add with all names(database name, user name,..).

Step 3: Database user in cPanel

How to Create new Database &Database user in cPanel - Database user in cPanel - steptoinstall

  • Add Username field: Enter a name for the user who manage the Database.
  • Add Password field: Enter the password with minimum 5 characters length and retype in below text-field
  • For help: You can generate a strong password, by clicking the Password Generator button.
  • Click Create User.

Step 4: Permissions for User

How to Create new Database - Permissions for User -  Permissions for User - steptoinstall

Select All Privileges to set security permissions the user(Who you created last step) has to the database and continue to the next step.

Note that the Username and Database name will be prepended with your Cpanel login name as pre-extension with underscore. For Example, this is my database name: mysite_sample. Here ‘sample’ is what i gave as database name in text-field. ‘mysite’ is cPanel user name.

Step 5: Database and User are created

How to Create new Database - Database user in cPanel - Database and User are created - steptoinstall

Finally, You created the Database and Database User as successfully.

Note:
Here Database host name is: ‘localhost’

How to Create new Database – Database user in cPanel

Just share...Share on FacebookShare on Google+Tweet about this on TwitterPin on PinterestEmail this to someone
The following two tabs change content below.
Buddies! Myself Tony George, lives in Southern states of India. A graduate professional in Software Engineering works as a Developer for an unique Software Development firm. During my leisure timings I used to write blogs related to all extra technicalities needed for an excellent coder. Google+

Latest posts by Tony Kuttan (see all)

This entry was posted in Database, Wamp.

3 Responses to How to Create new Database – Database user in cPanel

  1. Brigit v v says:

    good work…..

  2. bibin says:

    U did a great job Tony. Thank You Very much for this valuble Information. I Expect more updates from u.

  3. Samuel says:

    Thanks a lot

Leave a Reply

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

Please Fill this Sum * Time limit is exhausted. Please reload the CAPTCHA.