How do I 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 cPanel Control Panel located at http://ip address:2083.
  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. From the main page, under Databases, click MySQL databases.
  2. Enter a name for the database and click Create Database.
  3. Once the database creation completes, click Go Back.
  4. Enter a username and password for the database and click Create User.
  5. Once the user creation completes, click Go Back.
  6. Under Add User To Database, select the appropriate user and database.
  7. Click Submit.
  8. 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.

  • 1 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...

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...