Security Management


Adding Users

To add a new user select Tools -> User Manager -> Add Users. Provide the username, hostname and password and select the privileges that you want to give to the user. These privileges are Global. You will learn how to give Database/Table/Column-level privileges later in the tutorial. Remember, if you want to give a user permissions at the db/table/column level, don't give him global permissions in this dialog (use the Manage Permissions dialog instead).

Modifying Users

To edit an existing user's Global privileges, select Tool -> User Manager -> Edit User. Modify the required details and press Apply.

Managing Database/Table/Column Level Privileges

SQLyog's Manage Permission tool allows you to give database, table & column level privileges to any user. The Manage Permissions option can be found at Tools -> User Manager -> Manage Permissions (Ctrl+Shift+W).

Documenting your Database Using a Single Click

Many a times during development, developers need to create schemas of databases in standard format. You can do this through SQLyog with just a click of mouse. Select the Database -> Create Schema For The Database in HTML from the context menu (Ctrl+Shift+S) to create a schema in HTML. Moreover, the schema created is completely printer friendly with page breaks given between two tables.


Page 7: Saving Your Frequently Used SQL Scripts In Personal Folder