MySQL ODBC for Linux

標籤：

參考自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 PostgreSQLDriver        = /usr/lib/psqlodbcw.soSetup        = /usr/lib/libodbcpsqlS.soDriver64    = /usr/lib64/psqlodbcw.soSetup64        = /usr/lib64/libodbcpsqlS.soFileUsage    = 1# Driver from the mysql-connector-odbc package# Setup from the unixODBC package[MySQL]Description    = ODBC for MySQLDriver        = /usr/lib/libmyodbc5.soSetup        = /usr/lib/libodbcmyS.soDriver64    = /usr/lib64/libmyodbc5.soSetup64        = /usr/lib64/libodbcmyS.soFileUsage    = 1

 

vim /etc/odbc.ini

[flow-connector]Description    = MySQL connection to ‘mysql‘ databaseDriver        = MySQLDatabase    = mysqlServer        = localhostUserName    = rootPassword    = passwordPort        = 3306Socket        = /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