How to create a MySQL Database in cPanel

In this article we will be showing you how to create a MySQL database.  There are two options to create a database: MySQL Databases and MySQL Database Wizard.  The Wizard option is a much more simple option, and is highly recommended for anyone creating a database. We will be going through both options below.   

 

MySQL® Database Wizard

 

  • Enter a name for the database and then click Next Step, this will create the database.

New_Database.png

 

  • Now we will need to create a username for that database with a password.

Username.png

 

  • The Final step is to select what type of privileges to give to the MySQL user. In most cases  you will just select ALL PRIVILEGES.

__ALL_PRIVILEGES.png

 

MySQL® Databases

 

In this option you have more freedom of control over your database. You are able to delete or rename a database, delete a user from the database, or add multiple users to a single database. You are also able to change a MySQL user password, as well rename  or delete MySQL users. One last key feature is also the option to repair a database and fix any errors that show up.

 

  • First enter the name you want for the database and click Create Database

New_Database.png

 

  • Then scroll down to Add New User to create a new user for that database with a password.

Add_New_User.png

 

  • Now we need to add that user to the database and assign the privileges to the user. 

Add_User_To_Database.png

   

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.