How to create MySQL database and its User:

1- Create a MySQL Database:
 Log into cPanel.
Under Databases, click MySQL Databases.
In the New Database field, type a name for the database.
Click Create Database.
Click Go Back.
The new database will appear in the Current Databases table.
After creating the database, you have to create a user and assign privileges.
 
2- Create a Database User:
 
Log into cPanel.
Under Databases, click MySQL Databases.
Click Jump to MySQL Users in the top-right corner of the page.
Under Add New User, enter a username.
 Enter a password in the Password field.
For generating a strong password, click the Generate Password button.
Retype the password in the Password (Again) field.
Click Create User.
 
3- Assign Privileges to Database User:
 
Log into cPanel.
Click MySQL Databases.
Under Add a User to Database, select a user from the User drop-down menu.
From the Database drop-down menu, select the database for you wish to allow the user access.
Click Add.
Select the privileges you wish to grant the user, or select ALL PRIVILEGES.
Hit Make Changes.

Was this answer helpful? 60 Users Found This Useful (63 Votes)