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.
Mac OS X includes its own ODBC manager, based on the
iODBC manager. Mac OS X includes an
administration tool that provides easier administration of ODBC
drivers and configuration, updating the underlying
iODBC configuration files.
For Connector/ODBC 5.x, the package is provided as a compressed tar archive that you manually install.
In either case, the driver is designed to work with the iODBC driver manager included with Mac OS X.
To install Connector/ODBC 5.x:
Download the installation file for the appropriate level of Mac OS X (10.5 or higher).
Extract the archive:
shell> tar xvzf mysql-connector-odbc-
The directory created contains the subdirectories,
test. Copy the contents of
bin to a
suitable location such as
shell> sudo cp bin/* /usr/local/bin shell> sudo cp lib/* /usr/local/lib
Finally, register the driver with iODBC using the myodbc3i tool you just installed:
shell> myodbc3i -a -d -t"MySQL ODBC 3.51 Driver;Driver=/usr/local/lib/libmyodbc3.so;Setup=/usr/local/lib/libmyodbc3S.so"
To verify the installed drivers, either use the ODBC Administrator application or the myodbc3i utility:
shell> myodbc3i -q -d