How to create database and database user from cPanel?

Log in to cPanel using your username and your cPanel password at http://yourdomain.com/cpanel,
where yourdomain.com is your domain name.


1. Click on MySQL Database showing in Databases Menu

2. Now just type here your database name in New Database Field and click Create Database.

After Create Database we have to create a Database user that will access that Database.

3. Just type your database user name and type password and confirm password in both fields and click Create User.


After creating a Database User successfully now we have to connect that Database User with required Database Name.

4. Select User and Database from drop down menu and Click on Add Button.

After Click on Add button we have to assign User Privileges for mentioned MySQL Queries.
In my case i have assigned All Privileges to that database user to overcome any error in future.
Click on Make Changes to assign Privileges to that Database User. 
  • database, database user, mysql
  • 0 Uživatelům pomohlo
Byla tato odpověď nápomocná?

Související články

How to show hidden files (.htaccess) in cPanel File Manager?

Many users ask us how they can see the .htaccess files for their websites in cPanel File Manager....

How Can I Compress / Uncompress Files Using the File Manager?

How to Compress Files Go to the File Manager. Navigate to the folder where the files you want...

How to View Your cPanel Disk Space Usage?

In order to view your cPanel disk space usage, there’s a great tool located inside of your...

Accessing webmail for your domain

To access the included webmail email clients included with your hosting account, you’ll need to...

How to rename a database in phpMyAdmin?

phpMyAdmin is a free and opensource application for MySQL database management. It is one of the...