从软件库安装稳定版本
yum install unixODBC unixODBC-devel
libtool-ltdl libtool-ltdl-devel
yum install mysql-connector-odbc
要在rpm 语句后面加上
–nodeps –force,安装时忽略依赖关系,否则会提示error: Failed
dependencies:mysql-community-client-plugins
升级驱动到8.0
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm
–nodeps –force
vim /etc/odbcinst.ini ,配置修改如下
[PostgreSQL]
Description=ODBC for
PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1
[MySQL]
Description=ODBC for
MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1
[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
[MySQL ODBC 8.0 Unicode
Driver]
Driver=/usr/lib64/libmyodbc8w.so
UsageCount=2
[MySQL ODBC 8.0 ANSI
Driver]
Driver=/usr/lib64/libmyodbc8a.so
UsageCount=2
查看已经配置的驱动
odbcinst -q -d
[PostgreSQL]
[MySQL]
[MySQLw]
[MySQL ODBC 8.0 Unicode Driver]
[MySQL ODBC 8.0 ANSI Driver]
vim /etc/odbc.ini,配置修改如下:
[my_db]
Driver = MySQL ODBC 8.0
Unicode Driver
SERVER = 10.0.80.82
Description = MySQLw connection to ‘my_db’ database
PORT = 3306
DATABASE = my_db
OPTION = 67108864
USER = root
PASSWORD = 123456
CHARSET = UTF8
- Driver采用的驱动,与odbcinst.ini的名字要对应上
- SERVER数据库服务器的IP地址
- PORT数据库的端口
- DATABASE数据库的名称
- OPTION连接数如果是FreeSWITCH的连接需要配置这个
- USER数据库用户名
- PASSWORD数据库密码
验证是否成功
现在利用isql功能验证能连到你的数据库上,当你输入指令后会看到结果为1的返回值就表明连接成功了
echo “select 1” | isql -v my_db;
+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+
+———————+
| 1 |
+———————+
| 1 |
+———————+