OTL连接MySQL之unixODBC、mysql-connector-odbc安装配置
一、安装unixODBC
# su root
# cp unixODBC-2.3.2.tar.gz /usr/local
# cd /usr/local
# tar -vxzf unixODBC-2.3.2.tar.gz
# cd unixODBC-2.3.2
# ./configure --prefix=/usr/local/unixODBC-2.3.2 --includedir=/usr/include --libdir=/usr/lib64 -bindir=/usr/bin --sysconfdir=/etc
# make
# make install
二、安装mysql-connector-odbc
# su root
# cd /usr/local
# tar -vxzf mysql-connector-odbc-5.3.6-linux-glibc2.5-x86-64bit.tar.gz
# cd mysql-connector-odbc-5.3.6-linux-glibc2.5-x86-64bit/lib
# cp ./*.* /usr/lib64
三、配置odbc
vim /etc/odbc.ini
【注:以下是配置文件内容】
[test]
Driver = mysqlodbc
Server = localhost
User = root
Password = 123456
Port = 3306
Database = test
Charset = UTF8
Option = 3
vim /etc/odbcinst.ini
【注:以下是配置文件内容】
[mysqlodbc]
Driver = /usr/lib64/libmyodbc5w.so
Setup = /usr//lib64/libmyodbc5w.so
UsageCount = 1
四、测试连接
# isql test -v
【注:以下是成功的结果】
+—————————————+
| Connected! |
| sql-statement |
| help [tablename] |
| quit |
+—————————————+
五、说明
本人环境CentOS6.5 64位。