Browse by Category
Supports
Back to KB
 How to Create a Database in cPanel
cpanel, database, mysql, wordpress 0 views

Most applications, including WordPress, need a database before you can install them. Creating one in cPanel takes about a minute.

Steps

  1. Log in to cPanel.
  2. Under Databases, open MySQL® Database Wizard.
  3. Enter a name for the database and click Next Step.
  4. Create a database user and password on the following step.
  5. Grant that user ALL PRIVILEGES on the database and finish the wizard.

Note the full names

cPanel automatically prefixes both the database and the user with your cPanel account name. If your account is myaccount and you enter wordpress, the real database name is:

myaccount_wordpress

You must use the full prefixed name in your application's configuration. Using the short name is the most common reason a new installation cannot connect.

What to record

  • Database name, including the prefix
  • Database username, including the prefix
  • The password
  • Database host — almost always localhost

Store the password in a password manager. cPanel will not show it again, and recovering it means resetting it.

Was this article helpful?