Skip to main content

How to Create a MySQL User in cPanel

You can create a MySQL user in cPanel to manage specific database permissions for your website or application. This process allows you to assign a unique username and password to a database while restricting that user's access to only the necessary...

You can create a MySQL user in cPanel to manage specific database permissions for your website or application. This process allows you to assign a unique username and password to a database while restricting that user's access to only the necessary databases.

Before you begin

You will need:

  • A cPanel account with the appropriate permissions to manage MySQL databases.

  • A chosen username for the MySQL user (typically starting with your cPanel account prefix).

  • A secure password for the MySQL user.

Create a MySQL user

  1. Log in to your cPanel account.

  2. Locate the Databases section and select MySQL® Databases.

  3. Scroll down to the MySQL Users section.

  4. Enter a new username in the Add MySQL User field.

  5. Enter a password for the account in the Password field.

  6. Click Add User.

Confirm the result

  • The new user will appear in the list of MySQL users.

  • You will see a confirmation message indicating the user was successfully created.

Note: Assigning permissions

Creating a user only creates the identity; it does not grant access to a database. To allow the user to access a specific database, you must scroll to the Add Privileges section on the same page, select the user and the database, and click Add.

Did this answer your question?