Setting MySQL Security

You can use Mascon's Security Window to set up the security of your MySQL server. The Security window contains three tabs; User Privileges , Host Privileges and Grants . On the User Privileges tab one can create and remove users from the MySQL security tables as well as setting their privileges on any level (global, database, table and column) of the MySQL security scheme.

User Privileges

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 columns_priv tables (see setting a user’s privileges below).

Create a new user

1. Click the Add New User button on the toolbar, or select New User from the File menu

2. Enter the user name and press TAB

3. Enter the user host and press TAB

4. Enter the user’s password and press TAB

Remove an existing user

1. Select the user in the tree view

2. Click on the Delete user button, or select Delete User from the File menu

3. Mascon 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

2. If the global privileges must be changed, Click the Set Current Privileges on the toolbar or select Set Privileges from the File menu. The user’s Global Privileges will be displayed on the right hand side of the window

3. Set the user’s global privileges as required

4. 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 select Set Privileges from the File menu or Click the Set Privileges button on the toolbar

5. Set the user’s database privileges as required

6. Follow the same procedure for setting a table and column privileges.

Host Privileges

This tab shows the host table. You can also update the host table in this tab.

Grants

This tab displays the grants for the user selected in the User Privileges tab.