This topic describes how to manipulate user accounts with Fusion for MySQL Security Manager.
Security Manager provides an easy way to add, alter, or remove users visually without typing SQL code. To open the Security Manager, on the Fusion menu, select MySQL, then click Security Manager.
Open the Security Manager.
Click above the User List
-or-
right-click a user node and select New User on the shortcut menu.
Fusion for MySQL allows you to create a new user, based on the existing one. To do it, right-click the user in the Security Manager and select Duplicate Object in the shortcut menu. The right part of the editor will contain a new user, that is an exact copy of the existing one except its name. Make changes to the user if you need and save it. Note that no user will be created until you Save the changes.
Open the Security Manager and select the required user account in the tree. After editing, click the Save button on the Security Manager toolbar to apply changes. If you want to discard changes, click the Undo button on the Security Manager toolbar. You can view SQL statements that should be executed to apply changes. To view them, click the View Changes button on the Security Manager toolbar.
Open the Security Manager, right-click the account you want to delete, and select Delete on the shortcut menu, or select the required user in the list and click the Delete button above the User List, or press DELETE.