How to create a MySQL database in cPanel

Many website apps (including WordPress) need a MySQL database. cPanel's MySQL Database Wizard makes creating one quick.

Create the database and user

  1. Log in to cPanel and, under Databases, click MySQL Database Wizard.
  2. Step 1: enter a name for your database and click Next Step.
  3. Step 2: create a database user and a strong password, then click Create User.
  4. Step 3: tick ALL PRIVILEGES and click Next Step.

Note your details

Write down the database name, username and password — you'll need them when you install your app. cPanel adds your account name as a prefix (for example youracct_dbname).

Managing databases

To edit or remove databases later, use MySQL Databases, or phpMyAdmin to work with the data directly. Need help? Open a support ticket.

Was this answer helpful?

 Print this Article

Also Read

How to check your disk and bandwidth usage

Keeping an eye on your disk space and bandwidth helps you avoid surprises and know when it's time...

How to read your website error logs

When something on your site breaks, the error log is the first place to look — it records what...

How to set up a cron job

A cron job runs a script automatically on a schedule — handy for backups, WordPress tasks or any...

A tour of your cPanel dashboard

cPanel packs a lot of tools into one screen. Here's a quick tour so you know where things live....

How to back up your website in cPanel

Regular backups mean you can always roll back if something goes wrong. Your BPHOST plan includes...