Navicat for MySQL provides Manage Users to add, delete users, and edit global user privileges, and grant privileges on the selected databases, tables and fields.

The tree view on the left-hand side displays all the user/host combinations that exist in the user table. The tree view provides a drill down into the db, tables_priv and column_priv tables.

Create a new user

1. Click the Add User button on the toolbar
   
2. Enter the user name
   
3. Enter the user host
   
4. Enter the user's password and click OK
5. Edit other user properties on the appropriate tabs

Duplicate an existing user

1. Click the Duplicate User button on the toolbar
   
2. Enter the user name
   
3. Enter the user host
   
4. Enter the user's password and click OK
5. Edit other user properties on the appropriate tabs

Remove an existing user

1. Select the user in the tree view
   
2. Click on the Delete User button.
   
3. Navicat will confirm if you would like to remove the user@host from the other security tables (db, tables_priv and columns_priv) as well. Select Yes if you want to delete the user from the other security tables.

Setting a user's privileges

1. Select the user whose privileges must be changed. The user's Global Privileges will be displayed on the right hand side of the window
   
2. Set the user's global privileges as required
   
3. If the user's database privileges must be changed, Double Click on the user. A list of databases on the server will be displayed below the user. Select the database on which the user's privileges must be changed and click the Set Privileges button on the toolbar
   
4. Set the user's database privileges as required
   
5. Follow the same procedure for setting a table, column, stored procedures, functions and views privileges.