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

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 (see Privileges Provided by MySQL).

Just sample click to open the Manage Users window and use the toolbar below, allowing you to add, edit and delete users.

Add User

To add a new user

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Choose Edit -> Add User from the menu or click the Add User from the toolbar.
• Edit user properties on the appropriate tabs of the User Editor.

To create a new user with modification as one of the existing users

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Choose Edit -> Duplicate User from the menu or click the Duplicate User from the toolbar.
• Edit user properties on the appropriate tabs of the User Editor.

Edit User

To edit an existing user

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Select a user to edit in the tree view.
• Choose Edit -> Edit User from the menu or click the Edit User from the toolbar.
• Edit user properties on the appropriate tabs of the User Editor.

Edit User Privileges

To edit global user privileges

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Select a user to edit his/her privileges in the tree view.
• Edit global user privileges from the Global Privileges panel.

To edit user privileges for database, table/view, field and stored procedure/function

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Double-click a user to edit his/her privileges in the tree view.
• Select the specific object you wish to set privileges with.
• Edit database specific privileges from the Database Specific Privileges panel.
  or
• Edit table/view specific privileges from the Table Specific Privileges panel.
  or
• Edit field specific privileges from the Column Specific Privileges panel.
• Edit stored procedure/function specific privileges from the Stored Procedure Specific Privileges panel.

Delete User

To delete a user

• Select the connection you wish to set privileges with in the navigation pane.
• Click to open the Manage Users window.
• Select a user to delete in the tree view.
• Choose Edit -> Delete User from the menu or click the Delete User from the toolbar.
• Confirm deleting in the dialog window.