Online Documentation for SQL Manager for MySQL

Server security management

SQL Manager for MySQL provides the following tools for efficient MySQL security management:

• User Manager
• User Editor
• Grant Manager

Adding Users

In order to add a new user:

• select the Tools | User Manager main menu item or use the corresponding toolbar button to open User Manager;
• select the Add user... item from the context menu or within the Navigation bar;
• define user properties and permissions using User Editor.

Editing User Properties

In order to edit an existing user:

• select the Tools | User Manager main menu item or use the corresponding toolbar button to open User Manager;
• select the Edit user... item from the context menu or within the Navigation bar;
• edit the user properties and permissions using User Editor.

Managing Grants

To define grants on database objects:

• select the Tools | Grant Manager main menu item, or use the corresponding toolbar button to open Grant Manager;
• select the object type using the drop-down list on the toolbar;
• select a user from the Privileges for pane of the Navigation bar;
• edit user privileges using Grant Manager.

To define grants on tables, you can also:

• right-click a table in DB Explorer and select the Grants for Table <table_name> item from the context menu;
• edit user privileges using Grant Manager.

Deleting Users

In order to delete an existing user:

• select the Tools | User Manager main menu item or use the corresponding toolbar button to open User Manager;
• right-click the user to delete and select the Delete User item from the context menu or within the Navigation bar;
• confirm deleting in the dialog window.