Chapter 5. The MySQL Query Browser Connection Dialog

Table of Contents

5.1. Connection Dialog

5.1. Connection Dialog

Once MySQL Query Browser has been started, it displays a connection dialog window. You need to specify the MySQL server you are connecting to, the credentials needed for authorization on that server, which machine hosts that server (and which port it listens to), and the database (Schema) you will be querying. You may also specify a number of other options, if required.

You must choose a default database in order to issue queries. It is possible to choose a default database after connecting to the server, but setting the default from the connection dialog can save time on subsequent connections.

Figure 5.1. Connection dialog

Connection dialog

If the server connection is successfully established, all the values are saved for future connections (see the section that describes how MySQL Query Browser stores connection information). The Password field, however, is always empty: For security reasons, the password is not stored along with the other options, unless you explicitly specify otherwise in the General Options section of the Options dialog.

To set advanced connection options, click the Details button and check the desired options:

  • Use compression protocol - Use compression when communicating with the MySQL server.

  • Use SSL if available - Encrypt communications with the MySQL server using SSL. This option only applies if the MySQL client library on your client machine has SSL enabled.

  • Use ANSI quotes to quote identifiers - enclose all object names in double-quotes instead of back-ticks.

If you have difficulties connecting, please see the Troubleshooting Connection Errors section in the Troubleshooting Application Errors appendix.

You can change any of the values in the connection profiles just by overwriting the existing values with new ones. Similarly, if you select another connection profile, you can change any of its values. When you click the OK button after changing a profile's values, the changes are stored permanently only if a successful connection to the MySQL server is established. You can also click the ... button next to the Connection drop-down box. This brings up an Options dialog window that has a Connections section for modifying connection profiles. The values you can set are found in the Connection dialog window in the description of the Connections section of the Options dialog.