# How to create a MySQL database in cPanel

> Use the Database Wizard in cPanel to create a MySQL database, add a user, and grant privileges in a few quick steps.

Source: https://www.kualo.com/knowledgebase/cpanel-databases/how-to-create-a-mysql-database-in-cpanel
Updated: 2026-06-10

---

Most web applications - WordPress, Magento, online shops and forums among them - store their content in a MySQL database. On your Kualo hosting the quickest way to set one up is the **Database Wizard** in cPanel, which walks you through the whole job in four short steps: creating the database, adding a user, and giving that user access.

By the end you will have the three details your application needs to connect: a **database name**, a **username**, and a **password**.

## Step 1 - open the Database Wizard

Log in to cPanel and find the **Databases** section, then click **Database Wizard**.

![The Databases section of cPanel, with Database Wizard highlighted](https://kb-cdn.kualo.com/16/cd/16cd71739711e18d77ee10f2c884e657e32cbea2.png)

## Step 2 - name your database

Type a short, memorable name for the database and click **Next Step**. cPanel automatically adds your account username as a prefix (shown greyed-out to the left of the box), so the full name becomes something like `youruser_kbdemo`.

![Entering a name for the new database in Step 1 of the Database Wizard](https://kb-cdn.kualo.com/a9/25/a925ac551a6cb88d9141d8e8ee2999aa37113b37.png)

## Step 3 - create a database user

Every database needs at least one user before an application can connect to it. Enter a **username**, then a strong **password** in both boxes - the **Password Generator** can create one for you - and click **Create User**.

![Creating a database user with a strong password in Step 2 of the Database Wizard](https://kb-cdn.kualo.com/69/b8/69b868852f8085e7061897a9da2b95458a1466cc.png)

:::tip
Make a note of the username and password now. You will need them, together with the database name, when you set up your application.
:::

## Step 4 - grant the user access

So the user can read from and write to the database, tick **ALL PRIVILEGES** - this selects every permission in the list - then click **Next Step**.

![Granting all privileges to the database user in Step 3 of the Database Wizard](https://kb-cdn.kualo.com/3c/8e/3c8ee06513dbfb081a7e5ee0eb7f8ab3dae548b1.png)

If you would rather grant only certain privileges, leave **ALL PRIVILEGES** unticked and select just the individual permissions you need instead.

## You are done

cPanel confirms the task is complete and that the user has been added to the database. It is now ready to use.

Keep these three connection details to hand:

- **Database name** - your account prefix plus the name you chose, for example `youruser_kbdemo`
- **Database user** - for example `youruser_kbdemo`
- **Password** - the one you chose in Step 3

Enter them wherever your application asks for its database settings, usually in a configuration file or an installer screen. On Kualo shared hosting the database host is almost always `localhost`.

## Where to go next

- To browse your database, create tables or run queries, see [getting started with databases in phpMyAdmin](/knowledgebase/cpanel-databases/becoming-familiar-with-databases-in-phpmyadmin).
- To manage the databases and users on your account later - changing passwords, adjusting privileges or removing them - use the **Manage My Databases** tool in cPanel.
- If your website later shows an **"Error establishing a database connection"** message, work through [how to fix a database connection error](/knowledgebase/cpanel-databases/troubleshooting-error-establishing-a-database-connection).

If you get stuck at any stage, [open a support ticket](/knowledgebase/getting-started/how-to-create-a-support-ticket-in-mykualo) and our team will be glad to help.


---

_Source: Kualo Knowledgebase — https://www.kualo.com/knowledgebase/cpanel-databases/how-to-create-a-mysql-database-in-cpanel · © Kualo Ltd._