Portal Home > Knowledgebase > cPanel > cPanel 11 User Tutorials > How to create a MySQL database


How to create a MySQL database




Click to Watch

How to create a MySQL database:


MySQL allows you to store lots of information in an easy to access manner.


Steps to create MySQL database:


1) Click the 'MySQL Databases' icon in 'Databases' window.


2) Type the databse name in 'New Database' box.


3) Then click on 'create database'. The database will be created.


4) To add user to database first go back.


5) Then enter the new user to be added to your database in 'username' box. Also enter the password.


6) Click on 'Create User'. New user is created.


7) To link the new user to the database go back.


8) Check the 'user' and 'database' box. User name of hosting account is added to both user and database with underscore in between.


9) Click 'Submit' to add user to the database.


10) Click in 'All Privileges' box to assign All privileges to the user. Then click on 'Make Changes'.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Powered by WHMCompleteSolution