MySQL Workbench now includes an Error Log page in the administration workspace. Active local or remote connections can display entries from the Performance Schema table
error_log. For local connections to servers configured to write a traditional-format error log file, it can also display that file, including when the server is offline. An online local connection can switch between the Performance Schema and file sources. The page provides pagination, refresh, filtering by timestamp, priority, error code, subsystem, and message, and export of the complete selected log source. (WL #17345)-
MySQL Workbench now supports non-password authentication and multifactor authentication. Stored connections can configure up to three ordered authentication factors using password, Kerberos, LDAP, PAM, Windows, WebAuthn, OCI, OpenID Connect, or socket authentication. Method-specific options include client plugin directories, Kerberos client mode, OCI profiles, OpenID Connect token files, and WebAuthn device and privacy settings.
WebAuthn prompts and device-registration requests are displayed in the interface. The User editor can create and modify accounts with up to three factors, including no-login accounts and passwordless WebAuthn accounts.
It is also possible to reset the current or selected account's password, optionally retain the current password, discard an old password, and handle expired passwords.
See Advanced Authentication Support for more information. (WL #17354)
If the server
sql_modesystem variable includedANSI_QUOTES, MySQL Workbench could connect to the server, but the SQL editor remained at “Starting editor session...” indefinitely. (Bug #121375, Bug #40086368)