This section summarizes how the MySQL Workbench 8.0 release series progressed with each minor release.
SQL context help was enhanced to eliminate the requirement of having a valid MySQL connection to view the help topics and to improve the presentation of each help topic.
A new code-completion engine was added for use with object editors (triggers, views, stored procedures, and functions) in the visual SQL editor and in models.
Geometry fields displayed in the result grid now include a context-menu item that opens the specific location value in a browser. The selected point opens in
openstreetmap.orgby default, but an alternative online service can be used (see Section 3.2.7, “Other Preferences” ).
Support for invisible indexes was added for use when the active server supports the feature and the index is neither a primary key index nor a unique column (see Invisible Indexes). A new option in the Indexes subtab of the table editor (for both the SQL and modeling editors) provides index visibility when it is selected.
MySQL Workbench now provides a simple way to enable or disable the persisted global system variable settings introduced in MySQL 8.0 (see SET Syntax for Variable Assignment). For variables that can be persisted, a new check box enables configuration changes at runtime that also persist across server restarts and applies the persisted value, if one exists. Persistent system variables can be reset (to not persist) individually or collectively. For additional information, see Persist System Variables.
Support for Microsoft Windows Server 2016 was added in the MySQL Workbench 8.0.11 release.
MySQL Workbench source code has been reformatted according to Google style.
MySQL Workbench now supports the
caching_sha2_passwordauthentication plugin introduced in MySQL 8.0 (see Caching SHA-2 Pluggable Authentication).