Add a MySQL Database in cPanel

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:

  1. Open a web browser and connect to your WHM Control Panel located at https://<server_ip address>:2087.
  2. Login as the user for the domain.
  3. From the left side menu, under SQL Services, click Show MySQL Processes.

  4. 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.
  5. From the left side menu, under Service Configuration, click Service Manager.

  6. Check Enabled for mysql.

To add a MySQL database, please follow these steps:

  1. While still in WHM (https://<server_ip address>:2087), from the left side men under Account Information, click List Accounts. If you do not have this information, please skip to step 3.
  2. Find the appropriate domain and click the cPanel icon to enter the cPanel Reseller Menu. A new window will open and you will be logged in as the domain administrator for the domain.
  3. Once logged into cPanel for the domain (typically https://www.yourdomain.com:2083), click MySQL databases under the Databases section.
  4. Enter a name for the database and click Create Database.
  5. Once the database creation completes, click Go Back.
  6. Enter a username and a strong password for the database and click Create User.
  7. Once the user creation completes, click Go Back.
  8. Now you need to add the user to the database. Under Add User To Database, select the appropriate user and database.
  9. Click Submit.
  10. 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 and you can now connect to it from code or externally.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Check if IP is Blocked, How to Unblock it from Client Area

If you are hosted on a WHM/CPanel server with our Server Management package your servers you...

Check if IP is Blocked, How to Unblock it from Client Area

If you are hosted on a WHM/CPanel server with our Server Management package your servers you...

How do I access my webmail (Check emails using a browser)?

To login to your webmail use one of the following urls:CPanel...

Enabling Domain Keys In cPanel

cPanel by default provides the ability to enabled Domain Keys instead of the Exim MTA (Mail...

Enabling Domain Keys In cPanel

cPanel by default provides the ability to enabled Domain Keys instead of the Exim MTA (Mail...