首页 > 数据库技术 > 详细

MySQL ODBC for Linux

时间:2015-05-22 19:07:09      阅读:251      评论:0      收藏:0      [点我收藏+]

参考自http://blog.csdn.net/allens_zhou/article/details/8575400

 

centos7 64bit

yum install unixODBC unixODBC-devel mysql-connector-odbc

vim /etc/odbcinst.ini

# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[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


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[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

 

vim /etc/odbc.ini

[flow-connector]
Description    = MySQL connection to mysql database
Driver        = MySQL
Database    = mysql
Server        = localhost
UserName    = root
Password    = password
Port        = 3306
Socket        = /var/lib/mysql/mysql.sock

验证MySQL驱动,返回/etc/odbcinst.ini中的配置段标题表示成功,如:[MySQL]

odbcinst -q -d

现在利用isql功能验证能连到你的数据库上,当你输入指令后会看到结果为1的返回值就表明连接成功了

echo "select 1" | isql -v asterisk-connector

 

MySQL ODBC for Linux

原文:http://www.cnblogs.com/flowjacky/p/4522849.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!