Create MySQL database with CPanel

MySQL Databases allow you to store lots of information, and are required by many web applications like Blogs, (CMS) content management systems, forums, etc.

In a few steps with screenshots I will show you how to create MySQL database in CPanel with MySQL Database Wizard.

Login into your Cpanel and find the section called ‘Databases’.
Then click on the MySQL Database Wizard.

Create MySQL database with CPanel

On the next screen you will have to enter database name.
It really does not matter what name will be as usually you will copy and paste it any configuration file.
Certainly if you intend to connect remotely to MySQL database choose something easy to be written. More on the matter about remote MySQL access you will find at: how to allow remote connection to MySQL .

Anyway, put a name and click the ‘Next Step’ button.

Create MySQL database with CPanel

To access MySQL database you will need to create user of it since only MySQL users with privileges to access a database can read or write to that it.
The next step will be a database user creation.

Create MySQL database with CPanel

Choose a name, make strong password for you MySQL database and continue with the next step which is about the database user’s privileges.

Create MySQL database with CPanel

If you do not know that your application will need as an access the all privileges can be granted, but be aware that is not so good for the security.
Better refer to the application you intend to install and see what privilege options it will need.

When you are ready with your choices click next and the database will be created. You shall see a ‘Complete the task’ message, so either add another database, another user using the database area or return to home.

Create MySQL database with CPanel

Hope you managed to create without errors and warning messages your database.
Using wizard is probably the easier way to create MySQL databases in CPanel, and there is no need to understand it to use it. If you want to go deep into the matter and understand how to manage MySQL databse through SSH please check your database section or use the search field on our home page.

Filed Under: CPanel

Anthony Gee About the Author: Anthony G. is an IT specialist with more than 9 years of solid working experience in the Web Hosting industry. Currently works as server support administrator, involved in consultative discussions about Web Hosting and server administration. One of the first writers in the Onlinehowto.net website, now writing for Free Tutorials community - he is publishing tutorials and articles for the wide public, as well as specific technical solutions.

Leave a Reply