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:
- Log into cPanel & locate the MySQL Databases icon
- Scroll down and locate the MySQL Users heading
- Enter a username in the field provided
- Enter a password twice into the provided fields (or use the generator)
- Click “Create User“
- To delete a user, go to the section “Current Users” and the click “Delete“
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“.
Select the privileges you want the user to have or select “All Privileges” to give them all and then click “Make Changes“.