MySQL Workbench Manual
Known limitation with Ubuntu 20.04: An error related to FreeTDS/iODBC in Ubuntu prevents the migration of Microsoft SQL Server databases to MySQL using the MySQL Workbench Migration Wizard.
A new check box was added to the dialog for resetting an expired password. When selected it indicates that the server version in use precedes MySQL 5.7. (Bug #30799058)
-
MySQL Workbench now supports the following MySQL 8.0.19 and 8.0.20 server language features:
DROP CHECK,ALTER CONSTRAINT, andDROP CONSTRAINTinALTER TABLEstatements.Locking clause for query expressions.
Table values constructor.
Short table select syntax.
New requirements for the
CHANGE MASTERreplication statement (row format, primary key check).Failed login attempts and password lock time in
ALTER USERstatements.Format support for
EXPLAIN ANALYZEstatements.-
New and changed keywords:
ARRAYFAILED_LOGIN_ATTEMPTSMASTER_COMPRESSION_ALGORITHMMASTER_TLS_CIPHERSUITESMASTER_ZSTD_COMPRESSION_LEVELMEMBEROFFPASSWORD_LOCK_TIMEPRIVILEGE_CHECKS_USERRANDOMREQUIRE_ROW_FORMATREQUIRE_TABLE_PRIMARY_KEY_CHECKSTREAMTIMESTAMPTIME
(WL #13836)
MySQL Workbench Migration Wizard encountered
type -154(SQL_SS_TIME2) while copying Microsoft SQL Server tables, and it returned an error on the unhandled type. This fix adds the following new SQL data types to the wizard:SQL_SS_TIME2(supported by MySQL) andSQL_SS_TIMESTAMPOFFSET(not supported). (Bug #30884140)The
TableRead,TableInsert,TableUpdate, andTableDeleteevents for each table touched by a query did not include complete information in the Audit Inspector. (Bug #30807539)Valid
TABLEandVALUESstatements were identified as having syntax errors in the SQL editor. (Bug #30775372, Bug #98266, Bug #30775008, Bug #98263)MySQL accounts created during the prerequisite setup using the button were not granted sufficient privilege to schedule an online backup or to execute a full backup on Windows. (Bug #30774786)
The Table Data Import Wizard returned an error when used to import a large JSON file, rather than loading the file. (Bug #30733445)
Text selected in the SQL editor was blocked by the highlight color. (Bug #30369329, Bug #97070)
A change made to the
CREATEstatement to rename an existing stored procedure did not revise the corresponding name in the generatedDROP PROCEDUREstatement when the change was applied using the editor. This fix modifies the generated statement to no longer drop the original stored procedure after it is renamed. (Bug #30103689, Bug #96289)On Windows, statements that do not generate a result set, such as
INSERTorUPDATEstatements, caused MySQL Workbench to close unexpectedly after theEXPLAINoperation was executed and then the output type was selected. (Bug #27576669, Bug #89745)Although the installation and file path were valid, MySQL Workbench did not find the
ogr2ograndogrinfofiles when loading spatial data. (Bug #26447395, Bug #87074)A column created with
NULL ON UPDATE CURRENT_TIMESTAMP(6)prevented the MySQL Table Editor from showing table information, such as indexes, views, foreign keys, and so on. (Bug #26388250, Bug #86906)Memory use on a Windows host was excessive when a large result set was exported to a file, causing MySQL Workbench to become unresponsive. (Bug #26139027, Bug #86430)
Synchronizing a database that included a table with JSON fields to the data model produced new, separate tables for the JSON data, instead of updating the original table. In this instance, the target MySQL version set in the modeling preference, 5.6.30 by default, does not support the operation. This fix sets the default version to MySQL 8.0, but the value can be adjusted by selecting , Modeling, and then MySQL from the menu. (Bug #25788105, Bug #85648)
The zoom-out button did not alter the zoom level of spatial data when viewed from a Linux host, unless the zoom level was reset to the outermost level first. (Bug #25723313, Bug #85444)
MySQL Workbench became unresponsive for several minutes after a server startup attempt was made on macOS hosts. (Bug #25077227, Bug #83769)
No errors or warnings were reported when scheduling a backup with MySQL Enterprise Backup, although the backup did not execute as scheduled. (Bug #23562328, Bug #81788)
A Sybase database migration with the ODBC (FreeTDS) connection method produced an exception when the connection was tested. (Bug #23345282, Bug #81546)
MySQL Workbench server administration could not acquire management access to Oracle Solaris. For a list of supported platforms, visit https://www.mysql.com/support/supportedplatforms/workbench.html. (Bug #22453133, Bug #72204)
On Linux, edits made to values in the result grid were lost when using the pointer device to move within the grid, rather than pressing the Enter or Tab key to change the focus. (Bug #20742151, Bug #76387)
Forward engineering a valid MySQL Workbench model was unsuccessful when the operation was performed using a MySQL 5.5 server instance. (Bug #20637664)
On macOS, a query containing
SELECT @@hostnamereturned the column header, but the query did not show any visible output unless the first row below the column header was selected. (Bug #20540937)After reverting changes made to triggers in a schema that had been saved and synchronized, MySQL Workbench was not able to locate any differences when the reverted schema was re-synchronized with the model. (Bug #20222031)
A connection saved with MySQL Workbench Migration Wizard was no longer visible in the wizard after MySQL Workbench was upgraded to a later version. An attempt to save the connection again, using the same name, returned an error indicating that the original connection was preserved. (Bug #18454574)
No connection could be made to the PostgreSQL database system when it was selected as the source in MySQL Workbench Migration Wizard on macOS. (Bug #17299989)