How to Create a MySQL Database in cPanel

1. Log into cPanel and select MySQL Databases under the Databases heading
Click on the Create New Database button

2. Next to New Database enter a name for your database and click Create Database. A confirmation message will appear. Click Back to return to cPanel's MySQL Databases menu. Go to MySQL Users and click Add New User

3. Next to Username enter a username. Enter a password next to Password, enter it again for Password (Again) and then click Create User. A confirmation message will appear. Click Back to return to cPanel's MySQL Databases menu. Click Add User to Database

4. Select the user and the database and click Add. On the next page, you will assign privileges for the user to the database  Check the box next to All Privileges and then click Make Changes.

Your database and your user are set.

CAUTION
When you want to connect an application to the database (eg. joomla) the field Database should have the following format: cpanelusername_databasename
And for username, the format should be: cpanelusername_databaseuser

Your cPanel username is the same one you use to connect to your website's cPanel.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

I see old content after uploading new files

In case you've just updated your website, but you do not see any actual changes, it's your...

How to Install Joomla in Cpanel

The easiest way to install Joomla in cPanel is by using Softaculous. You should follow these...

How to change the password of your cPanel account

There may be times where you would like to change the password of your account. It is recommended...

Is Softaculous included in all cPanel and hosting plans?

Softaculous, that can be used to easily install applications in cPanel, is preinstalled in all of...

Unable to Connect to the Database: Could Not Connect to MySQL

If during or after installation, a blank page shows up with the message "Unable to connect to the...