Mac OS X is based on the FreeBSD operating system, and you can normally use the MySQL network port for connecting to MySQL servers on other hosts. Installing the Connector/ODBC driver lets you connect to MySQL databases on any platform through the ODBC interface. If your application requires an ODBC interface, install the Connector/ODBC driver. Applications that require or can use ODBC (and therefore the Connector/ODBC driver) include ColdFusion, Filemaker Pro, 4th Dimension and many other applications.
On Mac OS X, the ODBC Administrator, based on the
iODBC manager, provides easy administration
of ODBC drivers and configuration, allowing the updates of the
iODBC configuration files through
a GUI tool. The tool is included in Mac OS X v10.5 and earlier;
users of later versions of Mac OS X need to download and install
There are two ways to install Connector/ODBC on Mac OS X. You
can use either the package provided in a compressed tar archive
that you manually install, or use a compressed disk image
.dmg) file, which includes an installer.
To install using the compressed tar archive:
Download the compressed tar archive.
Extract the archive:
shell> tar xvzf mysql-connector-odbc-
The directory created contains two subdirectories,
these to a suitable location such as
shell> cp bin/* /usr/local/bin shell> cp lib/* /usr/local/lib
Finally, register the driver with iODBC using the myodbc-installer tool that was included in the package:
shell> myodbc-installer -a -d -t"MySQL ODBC 5.2 Driver;Driver=/usr/local/lib/libmyodbc5w.so"
To verify the installed drivers, either use the ODBC Administrator application or the myodbc-installer utility:
shell> myodbc-installer -q -d