How to create and modify MySQL databases in cPanel

After logged into cPanel, you click on MySQL Databases icon

create-mysql-database-in-cpanel

Create a new MySQL database
In New database: you type your database name

create-mysql-database-in-cpanel-4

Add a new user for your database that created before

create-mysql-database-in-cpanel-2
Type your username and password.

Click Create User to create one. After that you need to make relationship between database and username by adding privileges for them.

Check the privileges you would like this user to have from this database

create-mysql-database-in-cpanel-3

Click Make Changes to finish.

After create and connect your user to your database, you can go to PHPmyadmin to import data into the database you have just created in cPanel.

Leave a Reply