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).
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
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