Ubuntu 16 ODBC 连接 MySQL

说明：MySQL版本号5.7.33

MySQL --version
mysql  Ver 14.14 Distrib 5.7.33, for Linux (x86_64) using  EditLine wrapper

1、配置MySQL：/etc/mysql/my.cof

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock

2、安装odbc

sudo apt-get install unixodbc

3、下载对应驱动:mysql-connector-odbc

4、解压并移动到/opt目录下

sudo mv mysql-connector-odbc-5.3.13 /opt

5、配置驱动信息：/etc/odbcinst.ini

[MySQL]
Description=ODBC for MySQL
Driver=/opt/mysql-connector-odbc-5.3.13/lib/libmyodbc5a.so 
Setup=/opt/mysql-connector-odbc-5.3.13/lib/libmyodbc5S.so
FileUsage=1

6、配置访问数据库信息：/etc/odbc.ini

[db_name]
Driver = /opt/mysql-connector-odbc-5.3.13/lib/libmyodbc5a.so
SERVER = localhost
PORT = 3306
DATABASE = db_name
USER = root
PASSWORD = pwd

7、测试驱动

isql -v db_name