To install the driver from a tarball distribution
.tar.gz file), download the latest
version of the driver for your operating system and follow
these steps, substituting the appropriate file and directory
names based on the package you download (some of the steps
below might require superuser privileges):
Extract the archive:
tar xvf mysql-connector-odbc-5.2.2-i686-pc-linux.tar
The extra directory contains two subdirectories,
Copy their contents to the proper locations on your system
/usr/local/lib in this example;
replace them with the destinations of your choice):
shell> cp bin/* /usr/local/bin shell> cp lib/* /usr/local/lib
The last command copies both the Connector/ODBC ANSI and
the Unicode drivers from
/usr/local/lib; if you do not need
both, you can just copy the one you want. See
Choosing Unicode or ANSI Driver for details.
Finally, register the driver version of your choice (the
ANSI version, the Unicode version, or both) with your
system's ODBC manager (for example, iODBC or unixodbc)
using the myodbc-installer tool that
was included in the package under the
bin subdirectory (and is now under
/usr/local/bin directory, if the
last step was followed); for example, this registers the
Unicode driver with the ODBC manager:
shell> myodbc-installer -a -d -n "MySQL ODBC 5.2 Driver" -t "Driver=/usr/local/lib/libmyodbc5w.so"
This registers the ANSI driver:
shell> myodbc-installer -a -d -n "MySQL ODBC 5.2 Driver" -t "Driver=/usr/local/lib/libmyodbc5a.so"
Verify that the driver is installed and registered using the ODBC manager, or the myodbc-installer utility:
shell> myodbc-installer -d -l
Next, see Section 5.5, “Configuring a Connector/ODBC DSN on Unix” on how to configure a DSN for Connector/ODBC.