基础文件: mysql-connector-odbc-8.0.15-linux-glibc2.12-x86-64bit.tar.gz
可以从官网下载
-
解压该文件
-
cd 进文件
-
cp bin/* /home/trade/local/unixODBC/bin
-
cp lib/* /home/trade/local/unixODBC/lib
-
// Registers the Unicode driver: cd bin/ ./myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/home/trade/local/unixODBC/lib/libmyodbc8w.so"
-
// Registers the Unicode driver: shell> myodbc-installer -a -d -n "MySQL ODBC 5.3 Driver" -t "Driver=/home/trade/local/unixODBC/lib/libmyodbc5w.so"
-
myodbc-installer -d -l
-
配置 odbc.ini
[mysql] Driver = /home/trade/local/unixODBC/lib/libmyodbc8a.so Description = Connector/ODBC 8.0 ANSI Driver DSN SERVER = 远端ip PORT = USER = root Password = Database = mysql OPTION = 3 SOCKET =
-
cd /home/trade/local/unixODBC/bin
./isql -v mysql root 密码