Configuring MySQL ODBC DSN

Select MySQL ODBC 3.51 Driver, and then click Finish. The MySQL ODBC 3.51 Driver - DSN Configuration dialog box appears, as shown here:


Note: Upon clicking OK, the Data Sources dialog box appears, and the ODBC Administrator updates the registry information. The username and connect string that you entered become the default connection values for this data source when you connect to it.

You can also test whether your settings are suitable for connecting to the server using the button Test. This feature is available only for the MyODBC 3.51 driver.

The DSN configuration dialog also has an Advanced tab. If you select it, the following options dialog appears.
It is strongly recommended to select Use Compressed Protocol option to heighten driver performance