The following article explains how to add a MySQL database in cPanel. You can use cPanel's built-in MySQL database interface to add new MySQL databases. This procedure must be performed as the user for the domain, rather than as the administrator. Before you create the database, you must ensure the MySQL service is running.
To ensure the MySQL service is running, please follow these steps:
- Open a web browser and connect to your cPanel Control Panel located at http://ip address:2083.
- Login as the user for the domain.
- From the left side menu, under SQL Services, click Show MySQL Processes.
- If the screen is blank, you will need to start the service. If it displays information about processes, you can skip to the next section.
- From the left side menu, under Service Configuration, click Service Manager.
- Check Enabled for mysql.
To add a MySQL database, please follow these steps:
- From the main page, under Databases, click MySQL databases.
- Enter a name for the database and click Create Database.
- Once the database creation completes, click Go Back.
- Enter a username and password for the database and click Create User.
- Once the user creation completes, click Go Back.
- Under Add User To Database, select the appropriate user and database.
- Click Submit.
- Select the appropriate database permissions for the user and click Make Changes.
The database you created should now be displayed with the user you selected.