---
title: "How to Add a User to a MySQL Database in cPanel"
description: "Link an existing MySQL user to a database in cPanel and grant ALL PRIVILEGES or narrower permissions so your application can read and write its data."
url: "https://docs.noiz.ie/cpanel/how-to-add-a-user-to-a-mysql-database-in-cpanel/"
section: "cPanel"
categories:
  - "Control Panels > cPanel > Databases"
last_reviewed: "27 July 2026, against the current cPanel & WHM release"
---

# How to Add a User to a MySQL Database in cPanel

Creating a MySQL database and creating a database user are two separate steps in cPanel. A new user has no access to any database until you explicitly grant it. This guide shows you how to add an existing user to a database and assign the privileges that let the user read and write data.

**Last reviewed:** 27 July 2026, against the current cPanel & WHM release. 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 Documentation: Manage My Databases](https://docs.cpanel.net/cpanel/databases/manage-my-databases/)

## Prerequisites

- Access to your Noiz cPanel account.
- An existing MySQL database. If you have not created one yet, use the **Create New Database** section at the top of the same **Manage My Databases** page first.
- An existing MySQL user. If you have not created one yet, use the **Add New User** section on the same page and note the username and password.

cPanel automatically prefixes both database names and usernames with your account username, for example `youracct_shop` for a database and `youracct_appuser` for a user. Always use the full prefixed names when you configure an application.

## Add a User to a Database

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 **Add User to Database** section. Select a user from the **User** drop-down list, then select the target database from the **Database** drop-down list.
4. Click **Add**. ![The Add User to Database section with a user and database selected and the Add button highlighted](/img/add-db.gif)
5. On the **Manage User Privileges** page, tick **ALL PRIVILEGES**, then click **Make Changes**. ![The Manage User Privileges page with the ALL PRIVILEGES checkbox ticked](/img/add-privileges.gif)

The user is now linked to the database with the privileges you selected. Most content management systems and web applications, such as WordPress, expect the database user to hold **ALL PRIVILEGES** on their database, so this is the usual choice during installation.

## Granting Narrower Privileges

If an application does not need full control, you can tick only the specific privileges it requires instead of **ALL PRIVILEGES**. Common individual privileges include `SELECT`, `INSERT`, `UPDATE` and `DELETE` for day-to-day data access, plus `CREATE`, `ALTER`, `DROP` and `INDEX` for schema changes. Granting only what is needed reduces the impact if the credentials are ever exposed.

## Troubleshooting

**The user does not appear in the drop-down list**: the user must exist before you can add it. Scroll up to **Add New User**, create the user, then return to **Add User to Database**.

**Your application reports an access-denied error after linking the user**: confirm the application is configured with the full prefixed database name and username, that the password matches the one you set, and that the database host is set to `localhost`.

**You changed the privileges but the application still cannot write data**: re-open **Manage My Databases**, click the user under the relevant database to reach **Manage User Privileges**, confirm the required boxes are ticked, and click **Make Changes** again.

## Need a Hand?

If you are on a managed Noiz hosting plan and would like the Noiz team to set up or check a database user for you, open a support ticket from your client area and include the database and username involved.

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