MySQL is the relational database system, is considered to be much faster, cheaper and more reliable than various other database systems. The need of MySQL databases arises because it is important for various web applications like that of WordPress, Joomla, Drupal, etc.
If you are thinking of using these web applications for any work of yours, then you will have to know how to create the MySQL database, otherwise you won’t be able to carry on your work smoothly. The most interesting fact is that the users are quite satisfied with this relational database system, even though it lacks some of the most common features.
As a general user, you might not need to know what features are lacking in MySQL, but if you are a programmer who is trying to write computer programs, it becomes very important to know the advantage and disadvantage of the MySQL Database.
Steps to create MySQL Databases using CPanel
Now, let’s start with the process of creation of a MySQL database using cPanel. Once you set it up you will be able to make use of it for different web applications.
- The first thing to do in here is to login to cPanel
- Once you are at the Home Page of the cPanel, you will have to go to Database option and from there you will have to select the ‘MySQL Databases’
- When you click on that option, it will take you to the section which says ‘Create New Database’
- There you have to enter a new name that you want to give to the newly created MySQL Database
- After typing in the name in the box provided, you will have to click on the ‘Create Database’ button just next to it
- When you do that you will be informed about the creation of new database and you will be provided with a link, which says ‘Go Back’, you will have to click on that link
- It will take you to the database that has been created where you will find different sections, which are already filled up except for the ‘Users’ one that you need to fill up in order to access the database
- Just below the MySQL Users section you will find Add New User section where you will have to fill up all the relevant information, including the username and password that you would use to access the MySQL database
- Once you are done with updating the information, click on the ‘Create User’ button
- There will be another section just below the Add New User section, which is the Add User to Database
- Here you will get two dropdowns, choose the user that you created with the username on the front and the database that was just created
- Now Click on ‘Add’ and you are good to go
You just created your own database, but do note down the complete database name along with the username and password because you will require this information for allowing access to different web applications.