需要先安装MySQL Community Server 8.0.11和ODBC Manager,再安装MySQL Connector/ODBC 8.0.11。
$ brew install unixodbc
$ odbcinst -j
unixODBC 2.3.6
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /Users/Swiftie_Terrence/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
$ vim /usr/local/etc/odbcinst.ini
$ cat /usr/local/etc/odbcinst.ini
[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/local/mysql-connector-odbc-8.0.11-macos10.13-x86-64bit/lib/libmyodbc8a.so
[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/local/mysql-connector-odbc-8.0.11-macos10.13-x86-64bit/lib/libmyodbc8w.so
$ vim /usr/local/etc/odbc.ini
$ cat /usr/local/etc/odbc.ini
[MySQLServer]
Driver = MySQL ODBC 8.0 ANSI Driver
Server = 127.0.0.1
Port = 3306
Database = test
Charset = utf8
先下载MySQL Community Server 8.0.11,下载好后的安装教程
- cookie