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 back up your website in cPanel

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

How to add an addon domain

An addon domain lets you host a completely separate website — with its own domain — on the same...

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 use the cPanel File Manager

The File Manager in cPanel lets you upload, edit and organise your website files right from your...

How to create a subdomain

A subdomain is a separate section of your site with its own address, like blog.yourdomain.co.za...