Example of ODBC Settings for MySQL

The following example illustrates how you might edit odbc.ini to connect to a data source database named “TBCMYSQL” using a vendor-supplied ODBC driver.

[ODBC Data Sources]
ODBC_MySQL = MyODBC 3.51 Driver DSN

...

[ODBC_MySQL]
Driver = /usr/local/lib/libmyodbc3.so
Description = Connector/ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = root
Password =
Database = test
OPTION = 
SOCKET =