- To create a new MySQL database in our cPanel hosting panel, we must first access the control panel through the usual link:
http://alexander.kiubix.link/cpanel
- We access the Databases menu, in the section MySQL Databases.
- We create a new database MySQL by typing the name in the box and pressing «Create Database»
- Once the database is created, we will create the user that will work with the database.
- To create a User for the Database and a password for it. We will have to repeat the password twice for security or as the example Generate one and select I have copied the password in a safe place. Click on «Create User».
- We assign the User to the Database from «Add User to the Database». This step is sometimes confused by more inexperienced users. It is not enough to create a user and a database, it is totally necessary Link the User with the Database.
It is important that let's grant all privileges to the user so that it connects correctly with the Database.
What is a MySQL Database Good for?
MySQL databases are wildly popular even if you don't really know you're using them. For example, a MySQL database is necessary for file managers as common as WordPress, PrestaShop, Joomla !, Magento, etc ...
Any dynamic website needs a database to function properly since it is the place where all the information is stored.
For example, on this website that you are currently viewing while reading this article, makes use of a MySQL database.
When you have entered the page, the system has been in charge of generating the page, which is not a file hosted on a server, but is generated on the fly with each request from each user and each request generates a query to the database which is responsible for storing, archiving and offering the necessary content at all times.
No Comment