Creating a MySQL Database using Cpanel

1) Log into cPanel

2) Click on "MySQL Databases" under the databases section:


3) Type the database name (typically "cart", "blog", "xcart", etc), then click to create the database:



4) Give it a few moments, and cPanel will create the new database.  Click to return to the previous page:



5) Scroll down a bit, and you'll see an option to create a database user.  Fill in the user and a strong password, then click to create the user:
  • The database user password is case sensitive.
  • Please be sure to keep the password on hand - you'll need it to connect to your database later.

6) Give it a moment, and cPanel will create the new cpanel user.  Click to return to the previous page:



7) Scroll to the bottom, and you'll see the option to add the user to the database.  Select the appropriate user and database from the dropdown options, then click "Add":



8) Select the privileges you'd like to assign to the user.  (Typically all), then click to save the changes:



9) You should be able to use the following information to install your program:

Hostname: localhost
Database: cpaneluser_dbname (including the cpaneluser_  prefix and substituting your actual cpanel username)
Username: cpaneluser_dbuser (including the cpaneluser_  prefix and substituting your actual cpanel username)
Password: ********

Reviewed 12/21/16

  • Email, SSL
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

How do I access the Raw Logs from cPanel?

cPanel comes with a number of log analyzing programs such as AWStats and Webalyzer, but suppose...

I deleted a file in FileManager, how can I restore it?

If you have deleted a file in the File Manager from inside your cPanel all is not lost.  Just be...

Can't access cpanel - How to open a port in Windows Live OneCare - delete

This article is marked for deletion as it is relevant only to add-on software for Windows Vista...

How often are statistics generated?

It looks like the stats generate at different times. What time do they usually run? All of the...

How do I execute a PHP file from CRON?

  In order to execute a PHP file from the CRON, you need to add a line to your PHP script. It...