MySQL Workbench Manual
A new advanced tab was added to the MySQL Enterprise Backup profile editor. These options are stored in the [mysqlbackup] section of the backup profile, which is used by the MySQL Enterprise Backup executable through the
--defaults-fileparameter. (Bug #19643172)A new preference was added that defines whether pressing Tab inserts tab characters or spaces. (Bug #19598375, Bug #73189)
The EER diagram catalog browser now remembers view states on a per diagram basis. (Bug #19508483, Bug #72255)
A new Indentation section was added to the "General Editors" preferences. Included are options to set the indentation width and tab width. (Bug #17455648, Bug #70148)
Adding an SQL snippet now opens the snippet editor, when before it immediately added the snippet without a title or code review. (Bug #14724622, Bug #67085)
-
A new preference was added that limits the number of automatically opened SQL result sets for SELECT queries, which defaults to 50. Reaching this limit emits a warning.
Before, executing a large number of SELECT queries (about 800) at once would cause a fatal error after exceeding system CPU and memory limits. (Bug #12949811, Bug #62259)
A new Skip checking of Routine Definer option was added to the Catalog Diff Report wizard. This improves functionality for stored procedures and functions. (Bug #11764775, Bug #13418623, Bug #57645, Bug #63175)
Opening an SQL script no longer requires a MySQL connection. To do this, select from the navigation menu on the home page. (Bug #11757343, Bug #49377)
Inserting the locate() function inside another function would incorrectly report an SQL syntax error. (Bug #19856523, Bug #74439)
Compiling MySQL Workbench would fail on Hurd, kFreeBSD, s390x, and ppc64el systems. (Bug #19806379, Bug #74241)
Double-clicking on an object in the schema navigator (except for the schema name) now populates the SQL editor area with the object name. This restores previous behavior. (Bug #19788017, Bug #74299)
-
Connections to remote hosts using the connection method "Standard TCP/IP over SSH" would fail with new versions (1.15+) of the paramiko library.
A workaround was to downgrade the system's paramiko library. (Bug #19768621, Bug #74223)
Stored procedures that were identified as having syntax errors could not be saved. (Bug #19767233, Bug #74237)
MySQL Workbench generated incorrect UPDATE queries for tables without a Primary Key even where unique keys were present. (Bug #19711078, Bug #74140)
After typing Control + F and clicking , the entered text of the replace string was not fully visible. (Bug #19690226, Bug #74088)
On Windows, "Beautify/reformat the SQL script" could cause MySQL Workbench to freeze. (Bug #19667130, Bug #74020)
The Find's button would sometimes behave like the button. (Bug #19647189, Bug #73971)
Under Data Import/Restore, the "Enable Cleartext Authentication Plugin" option did not always function. (Bug #19598678, Bug #72433)
Under Users and Privileges, the text "Click the Drop button to completely remove the account" was changed to "Click the Delete button to completely remove the account". (Bug #19598511, Bug #73857)
A new Data Export preference was added that makes the
CREATE DATABASEandUSEstatements optional in the generated output. (Bug #19598433, Bug #72599)A new preference (check box) was added to optionally export triggers. (Bug #19598408, Bug #73718)
On Linux, the [x] button to close an SQL editor tab was missing if the required font package was not present on the system. Now, an image is used instead. (Bug #19598393, Bug #70993)
The SQL syntax checker would show errors for EXECUTE statements without the "using" keyword. (Bug #19560590, Bug #73804)
A new
GTID_PURGEDoption was added under "Advanced options" to the Data Export wizard. (Bug #19528673)There was a performance regression between 6.0 and 6.1/6.2 when switching diagram tabs, loading the model, and also adding new tables. The Catalog Tree was refactored for increased performance. (Bug #19524441, Bug #69184)
Exporting an ALTER script using the Synchronize with Any Source wizard after making "Column Mapping" (table name) changes would incorrectly generate CHANGE COLUMN queries as "CHANGE COLUMN `newcolumnname` `newcolumnname`" instead of "CHANGE COLUMN `oldcolumnname` `newcolumnname`". (Bug #19500938, Bug #73644)
Attempting to execute a query with one SQL editor tab while another SQL editor tab was causing a metadata lock would freeze MySQL Workbench. (Bug #19444247, Bug #73574)
The Auto-save scripts interval preference did not function, as auto-save saved all connection and query tabs every 10 seconds regardless of this setting. (Bug #19201716, Bug #73178)
Attempting to add multiple entries using the results view "Form Editor" would fail and generate an exception unless was clicked after each individual entry. (Bug #19185746, Bug #73253)
The Dashboard charts for Client Connections latest current value was always null, and the current, max, and limit values were overlapped. (Bug #18965879, Bug #72984)
The Server Status page did not recognize the enabled Memcached and Semi-Sync replication features. The status light for these features did not change from red to green. The System and Status Variables page reported the correct values for these features. (Bug #18703315, Bug #72531)
Custom user creation and MySQL Enterprise Backup was fixed to always function with a MySQL server started with the
skip_name_resolvesystem variable enabled. (Bug #17924757)Clicking at the password prompt for a Navigator option, such as System Status, would emit an unhandled exception. (Bug #17651774)
The SQL CREATE Script for Selected Object window under Object Migration in the migration wizard was narrow, and was missing a slider. (Bug #14823142, Bug #67189)
Font selection and support was improved. Some fonts, such as Cyrillic fonts, were not displayed properly. (Bug #12951450, Bug #62328)
When generating default INSERTs code for tables in modeling, columns that are specified NOT NULL will now replace NULL column values with the DEFAULT keyword. (Bug #11762839, Bug #55483)