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.
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.
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.
Choose a name,
make strong password for you MySQL database and continue with the next step which is about the
database user’s privileges.
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.
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.