centos odbc mysql_CENTOS7 配置odbc连接mysql

从软件库安装稳定版

# yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel

# yum install mysql-connector-odbc -y

查看是否正确安装

# 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

配置驱动相关文件

默认的libmyodbc5.so只支持ANSI字符集，为支持中文字符，需要使用libmyodbc5w.so。

# sudo vim /etc/odbcinst.ini

#在文件中添加如下内容

[MySQLw]

Description = ODBC for MySQL w

Driver = /usr/lib/libmyodbc5w.so

Setup = /usr/lib/libodbcmyS.so

Driver64 = /usr/lib64/libmyodbc5w.so

Setup64 = /usr/lib64/libodbcmyS.so

FileUsage = 1

查看已经配置的驱动

#odbcinst -q -d

[PostgreSQL]

[MySQL]

[MySQLw]

配置数据源

# sudo vim /etc/odbc.ini

[my_db]

Description = Data source MySQL w

Driver = MySQLw

Server = 127.0.0.1

Host = 127.0.0.1

Database = my_db

Port = 3306

User = root

Password = ******

CHARSET = UTF8

验证是否配置成功

# isql -v my_db