21.1.3.2. Installing Connector/ODBCon Unix

There are two methods available for installing Connector/ODBC on Unix from a binary distribution. For most Unix environments, you will use the tarball distribution. For Linux systems, there is also an RPM distribution available.

Note

To install Connector/ODBC 5.x on Unix requires unixODBC 2.2.12 or later to be installed.

21.1.3.2.1. Installing Connector/ODBC from a Binary Tarball Distribution

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 that demonstrate the process using the Linux version of the tarball, substituting the appropriate file and directory names based on the package you download:

shell> su rootshell> gunzip mysql-connector-odbc-5.2.2-i686-pc-linux.tar.gzshell> tar xvf
            mysql-connector-odbc-5.2.2-i686-pc-linux.tarshell> cd
            mysql-connector-odbc-5.2.2-i686-pc-linux

Read the installation instructions in the INSTALL file and execute these commands.

Then see Section 21.1.4.5, "Configuring a Connector/ODBC DSN on Unix" to configure the DSN for Connector/ODBC. For more information, refer to the INSTALL file that comes with your distribution.

21.1.3.2.2. Installing Connector/ODBC from an RPM Distribution

To install or upgrade Connector/ODBC from an RPM distribution on Linux, simply download the RPM distribution of the latest version of Connector/ODBC and follow the instructions below. Use su root to become root, then install the RPM file.

If you are installing for the first time:

shell> su rootshell> rpm -ivh mysql-connector-odbc-5.2.2.i386.rpm

If the driver exists, upgrade it like this:

shell> su rootshell> rpm -Uvh mysql-connector-odbc-5.2.2.i386.rpm

If there is any dependency error for MySQL client library, libmysqlclient, simply ignore it by supplying the --nodeps option, and then make sure the MySQL client shared library is in the path or set through LD_LIBRARY_PATH.

This installs the driver libraries and related documents to /usr/local/lib and /usr/share/doc/MyODBC, respectively. See Section 21.1.4.5, "Configuring a Connector/ODBC DSN on Unix" for the post-installation configuration steps.

To uninstall the driver, become root and execute an rpm command:

shell> su rootshell> rpm -e mysql-connector-odbc