Frequently Asked Question

FAQ / Linux Shared Hosting


How to create a MySQL Database in Cpanel?

Creating a MySQL Database:

Step 1: Login to your control panel. Click the MySQL databases.

Step 2: Under Create New Database, enter the database name and click Create database.

Step 3: This will create a database with the name mainuser_databasename.(mainuser refers to CPanel login username)



Creating a MySQL User :

Step 1: Under Current Users, enter the username and password and click Create User. This will create a user with username as mainuser_user.(mainuser refers to CPanel login username)

Creating a user does not automatically allow the user to use a database - you need to grant that user permission to the specific database first.

Granting Permission to MySQL User :

Step 1: Under Add Users to your Database, select the user(the user will appear as mainuser_user) you wish to grant permissions for(from the drop box next to User:).

Step 2: Select the database(the database will appear as mainuser_database) you wish to give that user access to(from the drop box next to Database).

Step 3: Select any privileges(abilities to modify the database) you wish the user to have by checking the box next to the privilege's name.

Step 4: Click on Add User to Database to give the user permission to access the database.(mainuser refers to CPanel login username).

Note: You are also provided with a Video Tutorial link on the top left corner that assists you in creating and modifying MySQL databases in cPanel.

How this faq is helpful:

Not at all
helpful
Not much
helpful
Some what
helpful
Very
helpful
Extremely
helpful

What could be better? (Optional)
X
  Not related to my issue
  Too complicated explanations
  Too much information
  Incorrect information
  Unclear information
  Incomplete information
  Too old information
Do you have any other feedback about this faq ?
1000

Related Tags :