If you want to set up any new website using CMS, you will need to create a database for it first. The Databases section in cPanel contains a number of options such as: Creating database, Managing the database. More importantly, cPanel allows you to work with MySQL and PostgreSQL databases.
In this lesson, we will explain how to create a MySQL database, but working with PostgreSQL is almost the same.
How to create a database
- Log in to cPanel.
- From the Databases menu, click on MySQL Database Wizard.
- In the Create database page, insert a name for the database you wish to create.
- In the Create Database Users page, insert a username and password.
- A new page will appear for setting the required privileges for the new database user, it is best to select the ALL PRIVILEGES option.
- Click Done. and the database will be successfully created.
Managing the created database
- Log in to cPanel.
- Click on phpMyAdmin.
- The database management control panel will appear.