Online Documentation for SQL Query for MySQL
Setting registration options
Select the database name from the corresponding drop-down list and specify its alias.
If necessary, select the Client charsetand Font charset.
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 on 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 database.
When done, click the Finish button to complete the Database registration process and start working with the newly registered database in SQL Query for MySQL.