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.

 

hs3223 - 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 on 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 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.