Manipulating User Accounts

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.

Creating a User Account

  1. Open the Security Manager.

  2. Click above the User List


    right-click a user node and select New User on the shortcut menu.

  3. Fill in the Name, Host, Password, and Confirm Password fields.
  4. If you want to create a proxy user account, fill in the Authentication and Authentication String fields as well. Also, set up Proxied User for a proxy user account.
  5. Grant necessary privileges to user.
  6. Optionally, set the server resources limit for the user.
  7. Click the Save button on the Security Manager toolbar.

Duplicating Users

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.

Editing a User Account

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.

Deleting a User Account

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.