LINUX通过ODBC连接MySQL

来源：互联网发布：gate奇幻自卫队知乎编辑：程序博客网时间：2024/06/04 18:20

1、下载MySQL驱动包
http://dev.mysql.com/downloads/connector/odbc/
2、解压MySQL驱动包到/usr/local文件下

#cp mysql-connector-odbc-5.3.7-linux-el6-x86-64bit.tar.gz /usr/local#tar -zxvf mysql-connector-odbc-5.3.7-linux-el6-x86-64bit.tar.gz

3、安装MySQL数据库驱动
进入MySQL驱动包bin目录

#cd /usr/local/mysql-connector-odbc-5.3.7-linux-el6-x86-64bit/bin#./myodbc-installer -d -a -n "MYSQL" -t "DRIVER=/usr/lib/libmyodbc5a.so;SETUP=/usr/lib/libmyodbc5a.so"

4、将libmysodbc5a.so放入/usr/lib 和 /usr/lib64下

#cp libmysodbc5a.so /usr/lib#cp libmysodbc5a.so /usr/lib64

5、配置odbcinst.ini 安装MySQL后自动生成

 [MySQL] Description     = ODBC for MySQL Driver          = /usr/lib/libmyodbc5.so Setup           = /usr/lib/libodbcmyS.so Driver64        = /usr/lib64/libmyodbc5.so Setup64         = /usr/lib64/libodbcmyS.so FileUsage       = 1

6、配置odbc.ini

[ZJYDPT] Driver=/usr/lib64/libmyodbc5a.soSERVER=10.x.x.xCHARSET=UTF8PORT=3306Database=databasename

7、查看定义的数据源

#odbcinst -q -s[ZJYDPT]

8、测试数据源连接情况

#isql -v ZJYDPT userName passWord+---------------------------------------+| Connected!                            ||                                       || sql-statement                         || help [tablename]                      || quit                                  ||                                       |+---------------------------------------+

0 0