Databases in cPanel
If your website uses a content management system (CMS) like WordPress, it will need a database to store all the important data and information, such as usernames, passwords, and posts.
This section is all about managing the databases – its tasks are mostly done via MySQL Databases and phpMyAdmin.
Create Databases and Manage MySQL Users
Click on MySQL Databases. On the New Database section, enter your desired database username and click Create Database.
A new database will be added to the Current Databases list.
To add a new MySQL user, scroll down to the MySQL Users section. There, enter the username and password and click Create User.
When you’re done, navigate to the Add User To Database section. Click on the dropdown menu and choose the new user and database – this will grant the user access to the selected database.
Once you’re done, you can start importing your files into this new database via phpMyAdmin. To ensure reliable site performance, try optimizing your database.