Tableau连接mysql需要安装iodbc驱动才可以连接mysql和mariadb。
通过MySQL ODBC官网dmg安装提示安装失败。所以只能手动安装，官网没看到手动安装iodbc 9.0的命令。手动安装也会遇到一些坑，比如安装时本地没有iodbc驱动报错。
1、到MySQL ODBC官网下载macOS 14 (x86, 64-bit), Compressed TAR Archive
$ brew install libiodbc
$ sudo ln -s /opt/homebrew/Cellar/libiodbc/3.52.16/lib/libiodbc.dylib ./
$ sudo ln -s /opt/homebrew/Cellar/libiodbc/3.52.16/lib/libiodbcinst.dylib ./
$ myodbc-installer -a -d -n "MySQL ODBC 9.0 Driver" -t "Driver=/usr/local/lib/libmyodbc9w.so"
如果遇到如下错误，说明iodbc没有安装好，检查一下上述libiodbc.dylib的文件路径是否正确
Referenced from: <AB8DD05E-9453-3228-A853-1F929DEDC217> /usr/local/bin/myodbc-installer
Reason: tried: '/usr/local/bin/../lib/libiodbc.dylib' (not a file), '/usr/local/bin/../lib/private/libiodbc.dylib' (no such file)
Reason: tried: '/usr/local/bin/../lib/libiodbcinst.dylib' (no such file), '/usr/local/bin/../lib/private/libiodbcinst.dylib' (no such file)
