Most of the sites require a database to store information about customers, products, articles and other information. At the moment we provide the opportunity to use 2 types of databases - MySQL and PostgreSQL. The most popular is the MySQL database. You can always find out which database is used by a specific content management system in the documentation or from the developer.
Database management is located in the Databases section.
To create a MySQL database, go to the MySQL Database Wizard. In the first step, you must specify the name of your database.
In the second step, you will be prompted to create a user for your database that will have access to it..
It is important to use a secure unique password. It is recommended to use a password generator. In the case of using an insecure password, the risk of hacking the database increases, as a result of which your data may be irretrievably damaged or replaced with third-party content. Also make sure that the password from the database user is stored in a safe place. After that click Create user.
In the third step, you will be asked to grant privileges to this user on the database. In the standard case, it is desirable to grant all privileges to the user. At this step, the creation of the database is actually completed and you can click the Back button to the MySQL main page to go to the MySQL user and database management page.
You can also go to the database management page from the cPanel main page, Databases -> MySQL Databases.
On this page you will be able to check the integrity of the database, as well as to restore it, in case of integrity violation.
It is possible to remove the database, or to prevent a specific MySQL user from accessing it.
cPanel also provides MySQL user management functionality, namely creating new users, linking to a specific database and deleting users.