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
STEP 1: To create MySQL Database in your cPanel you’ll need to login to your cPanel first.
STEP 2: Once you’re logged in, search for ‘Databases’ section. Click on ‘MySQL Databases‘. You’ll be taken to database creation wizard.
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.
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.
STEP 2: Choose the database name & database user from the drop downs & click on ‘Add’ button.
STEP 3: You’ll be taken to the privileges window. Check ‘All privileges’ & click on ‘Make changes’ button.
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.