ubuntu通过ODBC连接MySQL数据库

1.安装unixodbc 和 mysql_odbc_connector

apt install unixodbc
apt install unixodbc-dev

mysql-connector-odbc_8.0.21-1ubuntu20.04_amd64.deb下载
dpkg -i mysql-connector-odbc_8.0.21-1ubuntu20.04_amd64.deb

2.驱动配置

vim /etc/odbcinst.ini
配置如下
[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
UsageCount=1

[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
UsageCount=1

3.数据源配置

vim /etc/odbc.ini

配置如下
[MYSQL]
Driver = MySQL ODBC 8.0 ANSI Driver
Description = connection to MYSQL
Server = 192.168.8.50
Host = 192.168.8.50
Port = 3306
Database = mysql
CHARSET = UTF8
User = root<