SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.

Features :

Visual Tools*
Visual Schema Designer
Visual Query Builder
Migration Tools*
Wizard Driven Migration Toolkit
Import tasks can be scheduled
Synchronization Tools*
Schema Synchronization
Data Synchronization
Data Synchronization can be scheduled
Other Power Tools*
Scheduled Backups
Notification Services
Job Manager
Licensing*
Perpetual Licensing
Company wide Unlimited licensing at very attractive prices
DBA Productivity
Restoring/Importing large SQL dumps
MySQL 5.x objects support
User Management
Managing hosted MySQL
Connection Manager
Index Management
Relationship/Foreign Key Manager
Reorder Columns
Copy objects to another Host with single click
Table diagnostics
Flush Tools
Object Browser
Creating/dropping database
Optimized for managing Hosted MySQL
Multiple database connections
Table duplication with two clicks
Enhanced Productivity*
Smart Autocomplete
Intelligent Code Completion
Advanced Connectivity Options*
HTTP/HTTPs Tunneling
SSH Tunneling
SSL Connections
Internationalization
Complete Unicode/UTF8 Support
Developer / User Productivity
Favorites Manager
HTML Schema Documentation
Shortcuts to generate SQL DML statements from schema definition
Creating/Dropping/Altering tables
Multi-tab Query Editor and Result-set Editor
Multiple Query Execution
Multi-threaded Query execution - Ability to stop long running queries
SQL Templates
Excel-style grid interface to view/update resultsets
Multi-format Blob editor
View data in Grid/Text Mode
ResultSet/Data Export to CSV/XML/HTML/Excel
Full Support from 3.23.38 to the latest 5.x
Support for all MySQL table handlers
Excel friendly resultsets/table-data export to clipboard/file
Dialog-less table and resultset editor
Technology
Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way
to communicate with MySQL server
100% keyboard friendly
Small compact binary
Minimal use of Registry
Easy migration of User Preferences by dragging and dropping config files.
Non-cluttered look and feel, ability to show/hide panes

New
Features:
* Added an option to use Base64 encoding for communicating XML data stream with the HTTP tunneller. Using this option can be required to work around this XML-related bug in PHP.
* Improved editor performance with large scripts if Wordwrap was enabled.

Bug fixes:
* On Windows Vista Business edition, SQLyog could crash while closing down. No other Windows OS (and also not any other Vista edition) was affected.
* Also a ‘hang™ could occur when closing down. It could happen with all systems, but Windows Vista was mostly affected.
* Schema Sync failed with identically named Foreign Key CONSTRAINTs on identically named colums of basically same type (that could still differ in LENGTH, SIGNED/UNSIGNED specification etc.)

Miscellaneous:
* When a PK is built on a string column using a case insensitive collation, SJA could try to insert a row where the PK was identical to an existing one as compared “COLLATION-wise” (ie. when only LETTERCASE differed). That would result in ‘duplicate key™ error and the sync job would abort. We have now reverted back to case insensitive camparison with string-based PK™s as before 7.0, but (to avoid data loss/overwriting) we will abort sync of tables when a string-based PK uses a binary or case sensitive collation.