create a mysql database

From WebHostingNeeds.com
Jump to: navigation, search

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.

Create a Database User

Log into cPanel.
Under Databases, click MySQL Databases.
Click 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 strong password, click the Generate Password button.
Retype the password and Click Create User button.


You will be redirected to a screen where you will be prompted to choose the desired privileges. It is advisable to select All Privileges and click on the Make Changes button.