Online Documentation for SQL Query for MySQL
Setting registration options
Select a database from the list of selected databases and specify its alias. Repeat the operation and set the options below for each of the databases being registered at the host.
If necessary, select the client charset and font charset for the database.
Login prompt before connection
Check this option if you wish to be prompted for authorization information (User name and Password) each time you connect to the database.
Use compression protocol
Enables using the compressed data protocol when connecting to the database server.
Autoconnect at startup
Setting this option enables connection to the database automatically when the application is started.
Keep connection alive
Enables pinging the server before each query execution.
Use SSL protocol
Enables data interchange with the remote MySQL server via an encrypted channel, not allowing intruders to intercept your data.
Note that this option works only with the servers that support SSL connections.
Enables using the interactive_timeout variable value from the my.cnf file instead of wait_timeout for connection timeout.
Enables quoting all the identifiers with the backtick ('`') symbol.
Note that this option works only with the servers that support quoting aliases.
This option determines whether transactions will be used for the database or not.
Enable log of SQL Editor queries
Use this option to enable/disable SQL queries log.
This field is enabled if the Enable log of SQL Editor queries option is selected. Here you can specify the path to the *.sql file where SQL queries are logged.
If necessary, you can return to any of the previous steps using the Back button and make the appropriate changes for the currently registered MySQL host.
Click the Finish button to complete the Host registration process and start working with the newly registered host and database(s) in SQL Query for MySQL.