How to create a MySQL database in cPanel


This guide explains how to create a MySQL database and database user in cPanel. This will allow you to use the database for a Magento or WordPress site.

This uses the cPanel MySQL Database Wizard. It’s also possible to complete the process directly using phpMyAdmin, but this requires 2 separate steps.


A cPanel admin account.

For reference, these instructions were followed using cPanel version 88.0.11.

Skill Level

Basic knowledge of cPanel.


Time needed: 5 minutes.

  1. Log into your cPanel.

  2. Start the MySQL Database Wizard.

    In the Databases section, click MySQL Database Wizard.cPanel MySQL Database Wizard button - screenshot

  3. Create the database.

    In the New Database name field, enter a name for your database and make a note of it.
    Click Next Step.New Database name field and Next Step button - screenshot

  4. Create the database user.

    Enter the relevant details in the Username, Password and Password (Again) fields. Make sure the password is secure, and make a note of all the details in your favourite password manager.
    Click Create User.Username, Password and Password (Again) fields and Create User button - screenshot

  5. Set the database user privileges.

    Tick All Privileges.
    Click Next Step.All Privileges tick box and Next Step button - screenshot