一、下载与安装
下载地址(tar.gz):https://dev.mysql.com/downloads/connector/odbc/
安装: #tar -zxvf mysql-connector-odbc-5.1.13-linux-glibc2.5-x86-64bit.tar.gz
#mv mysql-connector-odbc-5.1.13-linux-glibc2.5-x86-64bit mysql-connector-odbc
#cd mysql-connector-odbc/lib
#cp /root/odb/mysql-connector-odbc/lib/libmyodbc5.so /usr/lib/
#cp /root/odb/mysql-connector-odbc/lib/libmyodbc5.so /usr/lib64/
#cd /root/odb/mysql-connector-odbc/bin
#./myodbc-installer -d -a -n "MySQL ODBC 5.1 Driver" -t "DRIVER=/usr/lib/libmyodbc5.so;SETUP=/usr/lib/libmyodbc5.so"
二、配置
假设unixodbc安装在/root/odb/uodbc下。
#vi /root/odb/uodbc/etc/odbc.ini
增加mysql的配置信息:
-------------------------------------
[mysql]
Driver = MySQL
Description = mysql
SERVER = 192.168.1.111
PORT