Commonly used configuration options and preferences include:
Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home screen.
Safe Updates: When enabled (default), MySQL Workbench will not execute
DELETEstatements if a key is not defined in the
WHEREclause. In other words, MySQL Workbench attempts to prevent big mistakes, such as deleting a large number of (or all) rows. Set from the SQL Editor preferences tab.
DELETE FROM foois considered unsafe, whereas
DELETE FROM foo WHERE id = 1is safe and will always execute.
Default Target MySQL Version: For modeling, set this Modeling MySQL preference to your target MySQL Server version. This affects the generated syntax and database structure in relation to how MySQL changed over time. Having the wrong version may generate invalid syntax for your MySQL server.
Combine Management Tools and Schema Tree: This refers to the left panel in the SQL Editor, where the Management and Schemas areas are on one or two separate tabs.
This behavior can also be toggled at runtime by clicking the icon.
Save snapshot of open editors on close: By default, MySQL Workbench saves all query tabs and reopens them when you restart it. Use the related Auto-save scripts interval setting to modify its behavior. Both are set from the SQL Editor preferences tab.
Related behavior: Right-click on an SQL tab and choose either (to save the tab to a file) or to close all other SQL editor tabs.
Enable Code Completion in Editors: Code suggestions can be activated either manually, or automatically if the related Automatically Start Code Completion setting is also enabled. In addition, enable Use UPPERCASE keywords on completion to code suggest upper case SQL keywords, such as
Related behavior: The Context Help right panel in the SQL editor displays documentation for SQL statements, and is disabled/enabled from the right panel. For example, typing
INSERTwill load documentation for the
INSERTstatement in the right panel.