MySQL ODBC 驅動安裝

標籤：cdn   建立   sysconf   blank   UI   install   esc   rom   編譯安裝   

一、線上安裝1、yum線上安裝驅動

# yum -y install unixODBC# yum -y install mysql-connector-odbc

2、配置驅動

（1）查看驅動程式相關資訊

# cat /etc/odbcinst.ini /************************************************# Example driver definitions# Driver from the postgresql-odbc package# Setup from the unixODBC package[PostgreSQL]Description = ODBC for PostgreSQLDriver = /usr/lib/psqlodbc.soSetup = /usr/lib/libodbcpsqlS.soDriver64 = /usr/lib64/psqlodbc.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************************************************/

（2）配置MySQL驅動

# cat /etc/odbc.ini #添加如下資訊/************************************************[mysql-hr]Driver = /usr/lib64/libmyodbc5.so #注意驅動程式的選擇Description = MyODBC 5 Driver SERVER = 192.168.235.140    #要串連的資料庫資訊PORT = 3306USER = rootPassword = rootDatabase = hrOPTION = 3charset=UTF8************************************************/

3、測試連接

（1）串連MySQL建立測試使用者、測試庫

mysql> grant all privileges on *.* to [email protected]192.168.152.129 identified by "root" with grant option;mysql> create database hr;

##註：賦權時host與對應的MySQL ODBC驅動中配置要保持一致，如為IP或者localhost

（2）測試連接

# isql mysql-hr test root -v ##文法：isql 資料來源名稱 使用者名稱 密碼 選項+---------------------------------------+| Connected! || || sql-statement || help [tablename] || quit || |+---------------------------------------+SQL>

二、編譯安裝

編譯安裝注意要預先安裝編譯工具，卸載預設安裝的驅動程式並選擇合適的版本。

1、MySQL建立測試使用者和測試庫

mysql> grant all privileges on *.* to [email protected]192.168.152.129 identified by "root" with grant option;mysql> create database test;

##註：賦權時host與對應的MySQL ODBC驅動中配置要保持一致，如為IP或者localhost

2、安裝驅動

yum -y install gcc gcc-c++ makewget http://www.unixodbc.org/unixODBC-2.3.4.tar.gzwget https://cdn.mysql.com//Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.9-linux-glibc2.12-x86-64bit.tar.gztar -zxvf unixODBC-2.3.4.tar.gz -C /usr/localtar -zxvf mysql-connector-odbc-5.3.9-linux-glibc2.12-x86-64bit.tar.gz -C /usr/local/cd /usr/local/unixODBC-2.3.4/./configure --prefix=/usr/local/unixODBC-2.3.4 --includedir=/usr/include --libdir=/usr/local/lib -bindir=/usr/bin --sysconfdir=/usr/local/etcmake && make install

編輯/etc/ld.so.conf

# cat /etc/ld.so.confinclude ld.so.conf.d/*.confecho "/usr/local/lib" >> /etc/ld.so.confldconfig

目的：解決錯誤 ./myodbc-installer: error while loading shared libraries: libodbc.so.2: cannot open shared object file: No such file or directory

註冊驅動

# ln -s /usr/local/mysql-connector-odbc-5.3.9/lib/libmyodbc5a.so /usr/lib/libmyodbc5a.so# /usr/local/mysql-connector-odbc-5.3.9/bin/myodbc-installer -d -a -n "MySQL ODBC 5.3.9 Driver" -t "DRIVER=/usr/lib/libmyodbc5a.so;SETUP=/usr/lib/libmyodbc5a.so"

3、配置驅動

# vim /usr/local/etc/odbc.ini 

內容如下：

[mysql-hr]Driver = /usr/lib/libmyodbc5a.soDescription = MyODBC 5 Driver SERVER = 192.168.152.129PORT = 3306USER = testPassword = rootDatabase = testOPTION = 3charset=UTF8

4、測試

# isql mysql-hr test root -v ##文法：isql 資料來源名稱 使用者名稱 密碼 選項+---------------------------------------+| Connected! || || sql-statement || help [tablename] || quit || |+---------------------------------------+SQL>

參考：

http://www.unixodbc.org/download.html
https://www.kysq.com/article/6e4a06c9f5.html

MySQL ODBC 驅動安裝