Managing Users in Your MySQL Database

Add new users to your MySQL database

To add new users to your MySQL database:

1. Log into your hosting control panel, and navigate to MySQL Database
   
2. In the left pane, select the database to which you wish to add users
3. In the right pane, click Add New User icon. The Add User dialog is displayed.
   
4. Enter the new user name, password, and password verification.
   • Normally we check for username uniqueness and password validity
5. Click Add User. The new user is added to your selected MySQL database
   
    

Change the user's password in your MySQL database

To change the password for a user in your MySQL database:

1. Log into your hosting control panel, and navigate to MySQL Database
   
2. In the left pane, select the database
3. In the right pane, find the user whose password you wish to change
4. Click the Change Password icon for the selected user. The Change Password dialog is displayed.
5. Enter the new password and verify it

Delete users from your MySQL database

To delete a user from your MySQL database:

1. Log into your hosting control panel, and navigate to MySQL Database
   
2. In the left pane, select the database from which you wish to delete users
3. In the right pane, find the username you wish to delete, then click Delete User icon for that username
4. In the verification dialog, click Delete User

Set or change database privileges for a user in your MySQL database

To set or change database privileges for a user in a MySQL database:

1. Log into your hosting control panel, and navigate to MySQL Database
   
2. In the left pane, select the MySQL database
3. In the right pane, for the selected username, click the Privileges icon. The Set Privileges dialog is displayed.
   
   1. Verify (in the dialog) that the correct database and user are selected
   2. Select Yes or No for the specific privileges you wish to give to this user
   3. When finished, click Set Privileges