MySQL is an open-source database management system. The first two letters My came from the name of it’s co-founder’s daughter & SQL stands for Structured Query Language. It’s very easy to create MySQL Database in cPanel. Creating only a MySQL Database won’t make it usable. You’ll have to walk some further. You’ll need to create an User & assign it to the MySQL Database to make it usable. So let’s see how to create MySQL Database

Create MySQL Database

cPanel Login Interface

STEP 1: To create MySQL Database in your cPanel you’ll need to login to your cPanel first.

databases

STEP 2: Once you’re logged in, search for ‘Databases’ section. Click on ‘MySQL Databases‘. You’ll be taken to database creation wizard.

create-mysql-database

STEP 3: Type in the database name & click on ‘Create database‘ button. Once the database is created, a confirmation message will appear on the top right corner of the browser.

Create an User

STEP 1: Go back to the previous window & scroll a little. You’ll find MySQL Users section right under the Current databases.

create-mysql-user

STEP 2: Type in your desired username in the Username field & then type in the password twice. Don’t forget to store the password for future use. Now click on ‘Create user’ button.

STEP 3: You’ll see a confirmation once the User is created.

Add User to Database

STEP 1: Go back to the previous window & scroll to the bottom of the page. You’ll find Add User to Database section there.

add-user-to-dabase

STEP 2: Choose the database name & database user from the drop downs & click on ‘Add’ button.

user privileges

STEP 3: You’ll be taken to the privileges window. Check ‘All privileges’ & click on ‘Make changes’ button.

add-user-confirmation

STEP 4: You’ll see a confirmation message once the user is added to the MySQL Database.

Congrats! Your MySQL Database is ready to use now.