How do I create a MySQL database in cPanel?

Applications like WordPress store their content in a MySQL database. If your hosting uses cPanel, the MySQL Database Wizard makes creating one quick. Here is how.

Using the MySQL Database Wizard #

1. Log in to cPanel.
2. In the Databases section, click MySQL Database Wizard.
3. Step 1: enter a name for your new database and click Next.
4. Step 2: create a database user with a strong password.
5. Step 3: assign the user to the database and grant All Privileges.
6. Finish the wizard.

Note the details you will need #

Write these down, as most applications ask for them during setup:

• Database name (often prefixed with your account name).
• Database username.
• Database password.
• Host: usually localhost.

Managing databases later #

• Use MySQL Databases to add users, change privileges, or delete databases.
• Use phpMyAdmin to browse tables and import or export data.

Tips #

• Use a unique password for each database user.
• Grant only the privileges an application needs.
• Export a backup before making big changes.

Troubleshooting #

• Application cannot connect: check the name, user, password, and that the host is localhost.
• Access denied: confirm the user is assigned to the database with the right privileges.
• Name looks different: remember cPanel adds your account prefix.

Need help? #

If your app will not connect to its database, our support team can help on live chat.