SQLyog Releases

Released: Sep 22, 2020

Updates in v13.1.7

Fixes

  • 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

Updates in v13.1.6

Features

  • 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.

Fixes

  • 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

Updates in v13.0.0

Features

  • 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...

Released: Jun 14, 2017

Updates in v12.4.3

Fixes

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

Released: May 17, 2017

Updates in v12.4.2

Features

  • 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.

 

Fixes

  • 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

Updates in v12.4.1

Features

  • 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).

Fixes

  • 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...

Released: Jan 25, 2017

Updates in v12.4.0

Updates in v12.4.0

Features

  • 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

Updates in v12.3.3

Updates in v12.3.3

Fixes

  • 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...

Released: Nov 18, 2016

Updates in v12.3.2

Updates in v12.3.2

Fixes

  • If an INIT_CONNECT setting in server configuration specified SET AUTOCOMMIT = 0 and global AUTOCOMMIT was 1 (or non-existent as in MySQL 4.1 and 5.0), the ‘transactions’ menu in SQLyog would incorrectly display AUTOCOMMIT as 1 after connection.
  • Same code change as above also fixes a crash that could occur with 4.1 servers.
  • Transactions support would fail to initialize with servers running global ANSI mode. SQLyog will not work in ANSI mode but connection and...

Released: Nov 16, 2016

Updates in v12.3.1

Updates in v12.3.1

Fixes

  • 12.3.0 introduced a slowness when displaying the saved connections list with a large no. (100+) of saved connections. This is fixed now.
  • Fixed a rare crash occurring sometimes when typing in the editor inside an invalid query longer than 128 characters. Auto-complete was at fault.