---
title: "How to Create a MySQL Database User in cPanel"
description: "Create a MySQL database user in cPanel with a strong password, understand the account prefix and length limit, then grant it access to a database."
url: "https://docs.noiz.ie/cpanel/how-to-create-a-mysql-database-user-in-cpanel/"
section: "cPanel"
categories:
  - "Control Panels > cPanel > Databases"
last_reviewed: "27 July 2026, against the current cPanel & WHM release using the default **Jupiter** interface"
---

# How to Create a MySQL Database User in cPanel

This guide shows you how to create a MySQL database user in cPanel on your Noiz hosting account. A database user (sometimes called a database username or MySQL login) is the account your website or application uses to connect to a database. Creating the user is one half of the job: on its own a new user cannot touch any data until you attach it to a database and grant it privileges, which is covered at the end of this guide.

**Last reviewed:** 27 July 2026, against the current cPanel & WHM release using the default **Jupiter** interface. This guide is written for Noiz hosting and is kept current against cPanel. It complements, and does not replace, the official cPanel documentation linked below.

### Official Documentation Reference

- [cPanel » Manage My Databases](https://docs.cpanel.net/cpanel/databases/manage-my-databases/): the full reference for creating users and databases, assigning privileges, and removing users.

## Prerequisites

- An active Noiz hosting account with cPanel access.
- Your cPanel login details (sent in your welcome email, or available from the Noiz client area).

## Create the MySQL User

1. Log in to your cPanel account.
2. In the **Databases** section, click **Manage My Databases** (named **MySQL Databases** on older cPanel versions). ![The MySQL Databases icon in the Databases section of cPanel](/img/mysql-databases-icon.gif)
3. Scroll down to the **MySQL Users** heading and find **Add New User**.
4. In the **Username** field, type the name for the new user.
5. Enter a password in the **Password** and **Password (Again)** fields, or click **Password Generator** to have cPanel create a strong one for you. Aim for a strength score of **Very Strong**. ![The Add New User form in cPanel showing the Username, Password and Password Again fields](/img/createdb-user.gif)
6. Click **Create User**.

cPanel confirms the new user and returns you to the **Manage My Databases** page.

## What You Need to Know Before You Start

- **Your account name is added automatically.** cPanel prefixes every database user with your account username and an underscore. If you type `appuser` and your account is `example`, the real login becomes `example_appuser`. Always use the full prefixed name in your application's configuration file.
- **Keep the name short.** The full prefixed username, prefix included, is limited to 32 characters on MySQL and 47 characters on MariaDB. If cPanel refuses a long name, shorten the part you typed.
- **Passwords must be strong.** The server enforces a minimum password strength, so a weak password is rejected on submit. The built-in **Password Generator** is the quickest way to satisfy it.
- **A new user has no access yet.** Creating a user does not connect it to any database. Until you grant privileges, connection attempts fail with an access-denied error even though the login exists.

## Next Step: Grant the User Access to a Database

To make the user usable, attach it to a database:

1. On the same **Manage My Databases** page, scroll to **Add User to Database**.
2. Choose the new user from the **User** menu and the target database from the **Database** menu, then click **Add**.
3. On the privileges screen, tick **ALL PRIVILEGES** for a standard application, then click **Make Changes**.

If you have not created the database yet, do that first in the **Create New Database** section at the top of the same page.

## Troubleshooting

**Symptom**: "The username you have chosen is too long." Shorten the part you typed; remember cPanel adds your account prefix, which counts towards the limit.

**Symptom**: The password is rejected on submit. It does not meet the required strength. Use the **Password Generator** or add length and a mix of upper case, lower case, numbers and symbols.

**Symptom**: The application reports "Access denied for user" after you created the login. The user exists but has not been added to the database. Complete the *Next Step* above to grant privileges.

**Tip:** Record the full (prefixed) database username and password somewhere safe. You will need both when configuring an application manually, and cPanel does not display the password again after creation.

If you would rather Noiz set this up for you, or you run into trouble, open a ticket from the Noiz client area and the support team will assist.

---
Source: https://docs.noiz.ie/cpanel/how-to-create-a-mysql-database-user-in-cpanel/