Thursday, 3 May 2012

Create a database and the user for that database in cPanel


How to create a database and the user for that database in cPanel

These are the steps to create a database and the user for that database in cPanel

1) Login to the cPanel
2) Go to "Databases"
3) Click on "MySQL Darabases"
4) Under "Create Database"
5) Enter the database name.
6) Click "Create Database"

Then create a user

7) Under "Add New User"
8) Enter the username
9) Generate the password.
10) Click "Add User"

Now add the user to the database.

11) Under "Add User To Database"
12) Select the user and the database name.
13) Click on "Add"

You will be prompt for "MySQL Account Maintenance", give the privilege for the user and make changes.

No comments: