How to create Create or Delete a Database User?

Create a Database User

 

1. Log into cPanel.

2. Under Databases, click MySQL Databases.

 

 

3. Click Jump to MySQL Users in the top-right corner of the page.

 

 

4. Under Add New User, enter a username. 

5. Enter a password in the Password field. (For help generating a strong password, click the Generate Passwordbutton.)

6. Retype the password in the Password (Again) field.

7. Click Create User.

 

 

Delete a Database User

 

1. Navigate to the Current Users section of MySQL Databases.

 

 

2. In the Delete column, click the Delete next to the user you wish to delete.

 

Define a User's Privileges

 

Privileges determine how a user is able to interact with the database. For example, privileges will dictate whether or not the user can add and delete information.

 

Assign Privileges to Database User

 

1. Log into cPanel.

2. Under Databases, click MySQL Databases.

3. Under Add User to Database, select a user from the User drop-down menu.

 

 

4. From the Database drop-down menu, select the database to which you wish to allow the user access.

5. Click Add.

6. From the MySQL Account Maintenance screen, select the privileges you wish to grant the user or select ALL PRIVILEGES.

 

 

7. Click Make Changes.