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.
Step 1: Go to MySQL Database Wizard
In cPanel, select MySQL Database Wizard from the Databases section.
Step 2: Enter Database Name
Enter a name for new database as your wish and continue to the next step.
Database name: sample
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
- 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
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
Finally, You created the Database and Database User as successfully.
Here Database host name is: ‘localhost’
How to Create new Database – Database user in cPanel