Administrate MySQL Databases With Ease Using a Graphical Interface

MySQL is probably the world’s most popular open source database engine but it can be difficult to administrate using its text-based tools and configuration files. SQLyog provides a full graphical interface to make using MySQL’s powerful features simple even for beginners.

Design Edit Administrate and Query MySQL Databases

SQLyog’s intuitive graphical user interface makes managing all aspects of your MySQL databases easy. Simple operations can be accomplished using the many pre-defined tools and functions while more complicated tasks can be built using the graphical editor which helpfully generates queries in correct SQL syntax to perform and learn from. SQLyog is able to handle databases of all sizes and can use SSH an HTTP tunnelling to make remote access simple and secure. Data transfer from external ODBC-compliant databases is also easy using the in-built import tool.

Opening Up MySQL’s Power to Everyone

There’s no doubt that the MySQL engine is highly powerful and flexible but managing its features through the standard text interface is daunting for beginners and a little clunky for even experienced users. SQLyog removes this barrier by making even its deepest functions available through a friendly and accessible interface. The one major downside is the complicated pricing structure offering several editions of differing power and functionality charged on a per-user licence.

Bug fixes

Changes

• Bug fixes

SQLyog is an easy-to-use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. There are a number of features designed to help you speed up your database development.

Top tools include:

• Shortcuts to quickly generate SQL statements and paste object names
• Learn MySQL by looking at the SQL generated by SQLyog
• Multi-tab query editor and result-set editor
• Multiple Query Execution
• Multi-threaded query execution with option 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
• Support for all MySQL table handlers