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

How to Install Joomla in Cpanel

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

Your connection to this server has been blocked

To protect servers from malware and security violations, multiple login attempts to an IP...

How to create a subdomain in cPanel

1. Log into Cpanel and go to Domains > Subdomains.2. You should fill in the following...

Help, I have deleted some files

If you have a backup of your website on your computer, use the 'Import Website' tool on cPanel...

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