linux mysql odbc驅動安裝_MySQL ODBC 驅動安裝

閱讀目錄

一、在線安裝

1、yum在線安裝驅動

2、配置驅動

3、測試連接

二、編譯安裝

1、MySQL創建測試用戶和測試庫

2、安裝驅動

3、配置驅動

4、測試

一、在線安裝

1、yum在線安裝驅動

# yum -y installunixODBC

#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 PostgreSQL

Driver = /usr/lib/psqlodbc.so

Setup = /usr/lib/libodbcpsqlS.so

Driver64 = /usr/lib64/psqlodbc.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

************************************************/

(2)配置MySQL驅動

# cat /etc/odbc.ini #添加如下信息/************************************************

[mysql-hr]

Driver = /usr/lib64/libmyodbc5.so #注意驅動程序的選擇

Description = MyODBC 5 Driver

SERVER = 192.168.235.140 #要連接的數據庫信息

PORT = 3306

USER = root

Password = root

Database = hr

OPTION = 3

charset=UTF8

************************************************/

3、測試連接

(1)連接MySQL創建測試用戶、測試庫

mysql> grant all privileges on *.* to test@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 test@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++ make

wget http://www.unixodbc.org/unixODBC-2.3.4.tar.gz

wget https://cdn.mysql.com//Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.9-linux-glibc2.12-x86-64bit.tar.gz

tar -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.conf

includeld.so.conf.d/*.conf

echo "/usr/local/lib" >> /etc/ld.so.conf

ldconfig

目的：解決錯誤 ./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.so

Description= MyODBC 5Driver

SERVER= 192.168.152.129PORT= 3306USER=test

Password=root

Database=test

OPTION= 3charset=UTF8