1 安装驱动包
yum install unixODBC-devel -y
yum install -y mysql-connector-odbc
2 配置数据源
[root@omserver-11 ~]# cat /etc/odbc.ini
[modules]
Description = MySQL
Driver = MySQL
SERVER = localhost
PORT = 3306
Database = config
USER = root
3 连接测试
[root@webmaster pyodbc-4.0.24]# isql -v modules root root
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+