Linux安装odbc连接mysql

--安装 unixODBC
yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel

--安装 MySQL Connector/ODBC 
官网下载rpm包
https://dev.mysql.com/downloads/connector/odbc/

安装
[root@test soft]# rpm -ivh mysql-connector-odbc-8.0.20-1.el7.x86_64.rpm 
warning: mysql-connector-odbc-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-connector-odbc-8.0.20-1.el7################################# [100%]
   
   
--测试odbc
[root@test soft]# odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

[root@test soft]# odbcinst -q -d
[PostgreSQL]
[MySQL]
[MySQL ODBC 8.0 Unicode Driver]
[MySQL ODBC 8.0 ANSI Driver]

--配置odbc.ini
vi /etc/odbc.ini
 
[mysql]
Description     = Data source sampleMySQL for accessing MySQL database sampleMySQL
Driver          = MySQL ODBC 8.0 Unicode Driver
Server          = 192.168.1.xx
Host            = 192.168.1.xx
Database        = mysql
Port            = 3306
User            = 
Password        =

--测试连接
[root@test soft]# isql -v mysql test test
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+