Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 18, 2002

Introducing SQLyog, a MySQL Front End - Page 6

By Staff

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

MySQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM