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.

 

hs3213 - Setting registration options

 

CheckBox 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.

 

CheckBox Use compression protocol

Enables using the compressed data protocol when connecting to the database server.

 

CheckBox Autoconnect at startup

Setting this option enables connection to the database automatically when the application is started.

 

CheckBox Keep connection alive

Enables pinging the server before each query execution.

 

CheckBox 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.

 

CheckBox Interactive mode

Enables using the interactive_timeout variable value from the my.cnf file instead of wait_timeout for connection timeout.

 

CheckBox Quote identifiers

Enables quoting all the identifiers with the backtick ('`') symbol.

Note that this option works only with the servers that support quoting aliases.

 

CheckBox Disable transactions

This option determines whether transactions will be used for the database or not.

 

CheckBox Enable log of SQL Editor queries

Use this option to enable/disable SQL queries log.

 

Log file

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.