Version History - 2024$$$SQLyog 13.3.0 (July 2024)$$$This release of SQLyog addresses new features and some bug fixes related to MariaDB.$$$$$$$$$New Features$$$--SQLyog now supports TLS 1.3 encryption for SSL connections.$$$$$$--SQLyog now supports the newly added collations in MariaDB version 10 and later above.$$$$$$--Added support for the new datatypes INET4; INET6; UUID in MariaDB version 10 and above.$$$$$$$$$Bug Fixes$$$--With MariaDB v11.1 and above; the bug preventing data insertion by displaying an empty drop-down list and clicking on the same leading to truncation of the existing data is fixed.

SQLyog 13.2.1 (November 2023)$$$This release of SQLyog addressed the most requested Quality Enhancements and some bug fixes. These enhancements are related to HTTP connections; schedule backups; Emoji updates; and Unique Identifiers. $$$$$$$$$Quality Enhancements:$$$--With Azure DB; SQLyog returned an error “unknown thread id” on stopping the query execution.--Emojis will be displayed as they are in the Table Data/Result tab; Scheduled Backups; Copy Database To Different Host/Database on setting the character set to utf8mb4 in the Init Command(s) field; under the Advanced tab of the respective connection and in the Scheduled Backups window.--The tunneller file for HTTP-tunnel connections has been updated with this release and must be replaced on the server.$$$Bug Fixes$$$--SQLyog used to abruptly close on altering a table having a column with CHECK constraint and Comment.--SQLyog displaying an empty HTTP Response dialog is fixed for connections through HTTP-tunnel.--Fixed a memory corruption issue with autocomplete that; in rare situations; could cause SQLyog to crash.--Fixed SQLyog failing to import the saved connections in some rare cases.--Selecting Edit a saved job and selecting a job file that has a connection with SSL enabled; the Use SSL Encryption checkbox was unchecked; and thus the connection failed.--Fixed SQLyog generating a wrong syntax in the Create/Alter Table if UUID or SYS_GUID were used as the default value for varchar columns.--SQLyog incorrectly interpreted the value CHECK for CHECK CONSTRAINT on a column with ENUM datatype.$$$Miscellaneous:$$$--The “keywords.db” file (used for syntax highlighting; autocomplete; and automatic letter case handling for functions and keywords) is updated with new keywords and functions added in recent MySQL and MariaDB servers.

SQLyog 13.2.0 (December 2022)$$$$$$$$$Bug Fixes:$$$$$$--With Azure DB; SQLyog returned an error “unknown thread id” on stopping the query execution.$$$--With Azure DB; SQLyog crashed when killing the query from another connection.$$$--When the ‘CA Certificate’ field is set to empty in a SSL connection; New Connection Using Current Settings and “Backup” failed and returned an error after restoring the session.$$$--In some rare cases; SQLyog would crash while restoring the session.$$$--With an HTTP connection; SQLyog crashed when you open the ‘Info’ tab on selecting the ‘Information_schema’ tables.$$$--With an HTTP connection; SQLyog closed abruptly when the option “Copy All/Selected Rows to clipboard” was selected in the RESULT tab.$$$--Indexes were incorrectly displayed for MySQL v5.1.x and below.$$$--Importing an excel file failed when the database collation was set to utf8mb4.$$$--Fixed an issue with SSH connection where SQLyog GUI could become unresponsive after switching from Read only to Edit mode in the RESULTtab.$$$--In some rare cases; the generated column’s condition was truncated in the expression field of the CREATE/ALTER TABLE UI.$$$--SQLyog failed to connect to a server through SSH with an Ed25519 encrypted private key.$$$--Fixed an HTTP connection failure issue with PHP v8.1. The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. $$$--SQLyog generated an incorrect ALTER TABLE statement in Schema synchronization with datatype TINYINT(1) for MySQL version 8.0.19 or above with any target MySQL version and vice versa.$$$Miscellaneous:$$$$$$--Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v 0.77; to support private keys generated in the PPK version 3 file format.

SQLyog 13.1.9 (January 2022)$$$$$$Features:$$$$$$--Updated the User Manager GUI to support the newly added privileges in MariaDB v10.5.$$$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 be replaced on the server. In the old tunneler file; curly braces were used for accessing array elements and string offsets; this behavior is deprecated. Also; some functions used are deprecated in PHP 7.4x.$$$--In some rare cases; the Schema Designer failed to add all the child tables of a parent table to the canvas.$$$--Explain Extended menu option is disabled for MySQL v5.7.3+ as it is deprecated.$$$--Database Synchronization wizard returned an error Column definition mismatch for DATETIME column on syncing the data from v5.7 to v8.$$$--SQLyog stopped responding when executing a query in an SSL connection through SSH-Tunnel.$$$--When an SSL connection was established through an SSH-tunnel; the New connection using current settings option failed to open the same connection; as the UI stopped responding and SQLyog had to be forcefully terminated.$$$Note:$$$ --Windows 7 Support has ended.