Doesn't work on Excel 2016 and macOS High Sierra

原文链接
Excel链接Mysql时，遇到很多坑，终于解决了，写下来和大家分享一下，希望能帮助到大家
I’ve macOS High Sierra 10.13.3. Using the package installer I installed the most recent iODBC Administrator 3.52.12 and the MySQL Connector ODBC 5.3.10.

After setting up a test database in MySQL and verifying that it all works well using Sequel Pro, I setup a user DSN in iODBCAdministrator.app for that database. The iODBC test of the DSN fails with:
When I use iODB Administrator64.app I get:

So it’s fine. When I do the same in Excel I get:

具体解决办法请大家查看最前面的原文链接。