How to create a MySQL database in cPanel?

To connect an application to MySQL or MariaDB, create a database, a user and the association between them in cPanel.

Create the database

1. Open Databases > Manage My Databases, or the Database Wizard.
2. Enter the desired name and confirm.
3. Note the full name displayed, including any account prefix.

Create the user

In the users section, choose a username and a unique password. Store the credentials securely. This password is separate from your Client Area or mailbox password.

Assign the user to the database

1. Select the user and database in the association option.
2. Add the user to the database.
3. Grant the privileges required by the application. An installer may need all privileges on its own database, but the user should not receive unnecessary access to other data.
4. Save your changes.

Configure and test the application

Enter the database name, username, password and host provided for your hosting account. Test the connection or installer. Creating a database does not automatically create its tables.

If the connection fails

Check the full names, user assignment and privileges before resetting the password. Use cPanel to manage databases and users, and phpMyAdmin to manage their data.

Interface illustrations

These screenshots show the versions used when the original article was written. Labels may differ in your current version; follow the written procedure and your account settings.

Related guides

• Sign in to your cPanel account