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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


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

Featured Database Articles

MySQL

Posted Dec 18, 2002

Introducing SQLyog, a MySQL Front End - Page 6

By DatabaseJournal.com 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


















Thanks for your registration, follow us on our social networks to keep up-to-date