Online Documentation for SQL Query for MySQL

Setting database options

The Options section of the Database Registration Info dialog allows you to set various options for the database.

Customize database options according to your needs. The detailed description is given below.

Login prompt before connection

Enables SQL Query for MySQL to prompt for user name and password each time you connect to the database.

Use compression protocol

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

Keep connection alive

Enables pinging the server before each query execution.

Interactive mode

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

Quote identifiers

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

Note: This option is only applied for the servers that support quoting aliases.

Autoconnect at startup

Check this option to specify that SQL Query for MySQL automatically establishes connection to the registered database at application startup.

Use SSL protocol

Enables interchanging data with the remote MySQL server via an encrypted channel, not allowing intruders to intercept your data.

Note: This option is only applied for the servers that support SSL connections

Disable transactions

Enables/disables transactions for this connection.

Transactions are used for controlling the changes on the server (e.g. for rolling back the changes of data and metadata). Also transactions are used for providing multiple access to the same data (more than one user can work with the same data at the same time). If you do not need to use transactions, you can disable them and each transaction will be committed after execution.