Loading...

Knowledge Base
Home 
 
/
 Managing Users in Your MySQL Database
Categories: My_SQL_Database, MySQL

Managing Users in Your MySQL Database

How to add new users to your MySQL database.
How to change a user's password.
How to delete users.
How to set or change database privileges for a user.


To add new users to your MySQL database:

  1. Log in to your account Hosting Summary. 
    Click for the Hosting Summary
  2. On the left pane, click on MySQL Management.
    MySQL Management link
  3. The next page will show your MySQL databases. Click the Manage link of the database to which you wish to add users.
    MySQL Databases List
  4. Scroll down to the Database Users section and look for the + Add New User link.
    database users list
  5. On the dialog box, enter the new user name, password, and password confirmation. Then click Next.
    Type a new password
    • Normally we check for username uniqueness and password validity.
  6. On the next dialog box, set privileges for your new user. Once done, click Save.
    Define your user's permission settings


Change the user's password in your MySQL database

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

  1. Log in to your account Hosting Summary. 
    Click for the Hosting Summary
  2. On the left pane, click on MySQL Management.
    MySQL Management link
  3. The next page will show your MySQL databases. Click the Manage link of the database where your users are.
    MySQL Databases List
  4. Scroll down to the Database Users section. Look for the username to be modified and click the three-dot menu on its right.
    Click the three-dot menu
  5. Click Change Password.
    Select Change Password
  6. The Change Password dialog is displayed. Enter the new password and confirm it. Then, click Save.
    Type your new password

Delete users from your MySQL database

To delete a user from your MySQL database:

  1. Log in to your account Hosting Summary. 
    Click for the Hosting Summary
  2. On the left pane, click on MySQL Management.
    MySQL Management link
  3. The next page will show your MySQL databases. Click the Manage link of the database where your users are.
    MySQL Databases List
  4. Scroll down to the Database Users section. Look for the username to be removed and click the three-dot menu on its right.
    Click the three-dot menu
  5. Click Delete User.
    Select delete user
  6. Click on Delete user.
    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 in to your account Hosting Summary. 
    Click for the Hosting Summary
  2. On the left pane, click on MySQL Management.
    MySQL Management link
  3. The next page will show your MySQL databases. Click the Manage link of the database where your users are.
    MySQL Databases List
  4. Scroll down to the Database Users section. Look for the username to be modified and click the three-dot menu on its right.
    Click the three-dot menu
  5. Click User Privileges.
    User Privileges
  6. The Set Privileges dialog is displayed. From here, you can specify the privileges you want to give to this user.
    Specify user privileges for this user
  7. Click the Save button once done.