MySQL Connector/ODBC Developer Guide
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:
$>gunzip mysql-connector-odbc-9.2.0-i686-pc-linux.tar.gz
$>tar xvf mysql-connector-odbc-9.2.0-i686-pc-linux.tar
The extra directory contains two subdirectories,
lib
and bin
.
Copy their contents to the proper locations on your system
(we use /usr/local/bin
and
/usr/local/lib
in this example;
replace them with the destinations of your choice):
$> cp bin/* /usr/local/bin $> cp lib/* /usr/local/lib
The last command copies both the Connector/ODBC ANSI and the
Unicode drivers from lib
into
/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
the /usr/local/bin
directory, if the
last step was followed); for example, this registers the
Unicode driver with the ODBC manager:
// Registers the Unicode driver: $> myodbc-installer -a -d -n "MySQL ODBC 9.2 Unicode Driver" -t "Driver=/usr/local/lib/libmyodbc9w.so" // Registers the ANSI driver $> myodbc-installer -a -d -n "MySQL ODBC 9.2 ANSI Driver" -t "Driver=/usr/local/lib/libmyodbc9a.so"
Verify that the driver is installed and registered using the ODBC manager, or the myodbc-installer utility:
$> 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.