The Options section of the Database Registration Info dialog allows you to set various options for the database.
Customize common database options according to your needs. The detailed description is given below.
Login prompt before connection
Use compression protocol
Enables using the compressed data protocol when connecting to the database server.
Enables using the interactive_timeout variable value from my.cnf file instead of wait_timeout for connection timeout.
Enables quoting all the identifiers with the backquote symbol ('`').
To make SQL scripts obtained using the Extract Database Wizard compatible with older versions of MySQL, uncheck this option.
Note: This option works only with servers that support quoting aliases.
Quote user names
Enables quoting usernames with the backquote symbol ('`').
Autoconnect at startup
Check this option to specify that SQL Manager for MySQL automatically establishes connection to the registered database at application startup.
Refresh objects on connection
This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.
Automatically reconnect when connection is lost
If this option is selected, the application attempts to re-establish database connection upon disconnect.
Use Unix line folding (\n) for text fields (for Unix-based servers)
Check this option to use the "\n" to mark the line break when saving data. The default value is "\n\r".
Don't use this database registration info to get server objects
If this option is enabled, the registration info of this database will not be used to establish server connection and get server objects (when expanding the Server Objects node in DB Explorer).
Use INFORMATION_SCHEMA database to refresh metadata
If this option is not checked then metadata is refreshed on the basis of the 'mysql' database.