Linux通过ODBC连接MYSQL

发表于

安装UnixODBC

YUM 直接安装

1、yum install unixODBC-devel

下载包安装

1
2
3
4
5
6
7
8
9
tar zxvf unixODBC-2.3.0.tar.gz
./configure --prefix=/usr/localunixODBC-2.3.0 \
            --includedir=/usr/include \
            --libdir=/usr/lib \
            --bindir=/usr/bin \
            --sysconfdir=/etc
make && make install

odbcinst -j

安装MYSQL的驱动文件

yum -y install mysql-connector-odbc

cat /etc/odbcinst.ini # 查看驱动程序信息

配置ODBC驱动

vim /etc/odbc.ini

1
2
3
4
5
6
7
8
9
10
11
12
[mysql_229]
Description = mysql
Driver = MySQL ODBC 8.0 ANSI Driver
Server = 192.168.7.229
Database = test
Port = 3306
USER = test
Password = test
Socket =
Option =
Stmt =
CHARSET = UTF8

Driver 填写驱动程序信息中每种驱动的描述

测试ODBC连接情况

isql mysql_229 -v # 连接某个数据源

strace isql mysql_229 -v # 跟踪错误信息