SQLyog Ultimate のリリース

Released: Jan 11, 2022

v13.1.9 での更新項目


  • Updated the ‘User Manager’ GUI to support newly added privileges in MariaDB v10.5.


  • Changes in SQLyog MySQL13.1.9 GUI include the following bug fixes:
    • SQLyog returned an error when setting user server resources like maximum number of queries per hour, Maximum number of updates per hour, Maximum number of connections per hour, or Maximum number of user connections using User Manager GUI for MySQL v8+ Servers.
    • The tunneler file for HTTP-tunnel has been updated with this release and must...

Released: Apr 29, 2021

v13.1.8 での更新項目


  • With MariaDB System-Versioned tables, SQLyog was hanging when clicking on SQL Preview in the Alter table wizard.
  • Indexes were not being displayed with MariaDB System-Versioned tables.
  • In some cases, LOAD DATA LOCAL INFILE query failed to be executed from the Query Editor.
  • Schema Sync tool generated incomplete queries if the table contained an exceptionally long ENUM data type.
  • In some rare cases, Schema Sync failed to sync the mismatch, even after executing the query generated by the...

Released: Sep 22, 2020

v13.1.7 での更新項目


  • Unable to connect to a MySQL server using SSL when the client doesn’t provide a CA Certificate file, prior to version 10.4.
  • When Editing a MySQL user password, the MariaDB server version was not working.
  • The Calculate Optimal Datatypes in the Info tab returned syntax error for MySQL version 8 and above.
  • When the chunk size was set equal to 0 the Copy Database was not working properly.
  • SQLyog returned random errors when importing a SQL dump using HTTP tunnel.
  • If the connection names and...

Released: Apr 30, 2020

v13.1.6 での更新項目


  • An option has been added to specify the authentication plugin while creating/altering the user. This option is available for MySQL 5.7+ and MariaDB 10.4+ servers.
  • Now, it is possible to create invisible and descending indexes. This option is available for MySQL 8.0.11+ servers.

Important Note: The 32-bit version has been discontinued from this version.


  • In some rare cases, SQLyog failed to connect MySQL over an SSH tunnel.
  • The saved connection names longer than 44 characters were...

Released: Apr 5, 2018

v13.0.0 での更新項目


  • Added an option to the ‘Scheduler and Reporting tool’ to attach query result(s) as CSV files.
  • Errors returned from queries are now logged to HISTORY tab.
  • Added an option to collapse all expanded objects in the Object Browser in a single operation.
  • Upgraded Visual Studio build environment from the old 2010 version*.
  • Upgraded OpenSSL and SQLite to current versions.
  • ‘ROW_FORMAT’ parameter is now handled in the Schema Synchronization comparison.

* Note: The upgrade of Visual Studio means that...

Released: Jun 14, 2017

v12.4.3 での更新項目


  • Upgrades the MariaDB Connector/C to version 2.3.3 (current) which resolves incorrect timeouts on some environments.

Released: May 17, 2017

v12.4.2 での更新項目


  • Search function in Object Browser now supports regular expressions.
  • Important Notice: The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. Earlier HTTP-tunnel required PCRE-support in the server-side PHP-environment. Now it does not.



  • Fixed a rare connection failure using SSH-tunnel to specific BSD systems.
  • Removed unnecessary virtual column check for older servers with no support for this.
  • Fixed a crash when a menu-item, that is...

Released: Mar 1, 2017

v12.4.1 での更新項目


  • Added an option to HEX-dump binary data in Export as SQL and in Scheduled Backup.
  • In read-only mode FLUSH-statements can now be executed from the GUI as well as editor, except for ‘FLUSH TABLE WITH READ LOCK’ (as SQLyog doesn’t allow acquiring explicit LOCKS in read-only mode).


  • On enabling HTTP, SSL or SSH checkbox in the connection manager, the checkbox wasn’t redrawn automatically. The checkbox were re-drawn only on hovering over them or switching to another tab in the connection...

Released: Jan 25, 2017

v12.4.0 での更新項目

Updates in v12.4.0


  • Added an option for defining a connection as ‘read-only’.  There is a checkbox in the connection settings and when checked the title bar will inform user about the ‘read-only’ state. In ‘read-only’ state statements that write cannot be executed.
  • Added support for the MariaDB auth_gssapi (Kerberos) plugin. This plugin is available with the latest 3.0 (alpha) Connector/C from MariaDB. But there seems to  be a huge popular demand for this already, and Webyog has backported...

Released: Dec 26, 2016

v12.3.3 での更新項目

Updates in v12.3.3


  • Fixed an issue where Import External Data -jobs failed to authenticate SMTP.
  • The sja.log would record syntax errors on recent servers if  Scheduled Backup was running with ‘Flush Master’ option. The generated backup file was OK. ‘Flush Master’ was deprecated in MySQL 5.6 and replaced with ‘Reset Master’. SQLyog now uses ‘Reset Master’ with such servers.
  • In email settings of Import External Data wizard it was possible to leave the subject empty.
  • When re-ordering columns...