通过ODBC连接Mysql数据库

#安装 unixODBC
yum install unixODBC.x86_64 unixODBC-devel.x86_64
#查看odbcins.ini配置文件
cat /etc/odbcinst.ini 
#验证系统能否找到驱动
odbcinst -q -d

#下载，安装 unixODBC 驱动
wget https://mirrors.huaweicloud.com/centos/7/os/x86_64/Packages/mysql-connector-odbc-5.2.5-8.el7.x86_64.rpm
rpm -ivh mysql-connector-odbc-5.2.5-8.el7.x86_64.rpm
查看安装路径
rpm -ql mysql-connector-odbc-5.2.5-8.el7.x86_64

ll /usr/lib64/libmyodbc5.so

#编辑odbc.ini
vi /etc/odbc.ini

[test]
Description = MySQL test database
Driver = mysql
Server = 192.168.3.XX
User = root
Password =XXXX
Port = 3306
Database = mysql

#验证 ODBC 是否可用
isql test