Knowledgebase Home / How to Create and Delete a MySQL User in cPanel

How to Create and Delete a MySQL User in cPanel

This tutorial will explain how to create a MySQL database user in cPanel. Once created, you’ll want to assign it to a database.

Quick Steps:

  1. Log into cPanel & locate the MySQL Databases icon
  2. Scroll down and locate the MySQL Users heading
  3. Enter a username in the field provided
  4. Enter a password twice into the provided fields (or use the generator)
  5. Click “Create User
  6. To delete a user, go to the section “Current Users” and the click “Delete

To create a MySQL database you’ll need to locate and click the “MySQL® Databases” icon.

cPanel MySQL Databases Tool

cPanel MySQL Databases Tool

Create MySQL User

After you have clicked the MySQL® Databases icon, go to the “MySQL Users” section as shown below:

Add new mySQL user in cPanel

Add new mySQL user in cPanel

Enter the username you wish to add in the username field and create or generate a password. After that click on the “Create User” button. Now the database user has created successfully and you’ll see a screen similar to that of shown below.

cPanel MySQL Databases user successfully created

cPanel MySQL Databases user successfully created

Scroll down to the “Add User To Database” section to assign a user and grant permissions to a MySQL database. Then choose the specific user from the drop-down list and the corresponding database you wish to allow the user access to. When ready click “Add“.

cPanel add user to MySQL database

cPanel add user to MySQL database

Select the privileges you want the user to have or select “All Privileges” to give them all and then click “Make Changes“.

cPanel manage MySQL user privileges

cPanel manage MySQL user privileges

Delete MySQL User

To delete a MySQL user, simply click the delete icon listed next to the user you want to delete. You also have the option to reset a user password or completely rename the MySQL user account.

Creating & deleting a mySQL user in cPanel

cPanel MySQL user options

Conclusion

You can add, modify, and delete databases and users, as well as manage user database permissions.

If the steps above listed in this article do not resolve your issue, please feel free to open a support ticket and we’d be happy to take a look.

Our Guiding Principles

  • Provide consistent, stable and reliable web hosting services.
  • Ensure rapid ticket response and quick resolutions to issues.
  • Never saturate or over-provision servers to ensure stability and speed for our customers.
  • Use only high quality enterprise-class hardware to ensure minimal downtime from hardware failures.
  • Provide clear pricing with no hidden fees or gotchas.