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.
The method for installing Connector/ODBC on Mac OS X depends on
the version on Connector/ODBC you are using. For Connector/ODBC
3.51.14 and later, the package is provided as a compressed tar
archive that you manually install. For Connector/ODBC 3.51.13
and earlier the software was provided on a compressed disk image
(.dmg) file and included an installer.
In either case, the driver is designed to work with the iODBC driver manager included with Mac OS X.
To install Connector/ODBC 3.51.14 and later:
Download the installation file. Note that versions are available for both PowerPC and Intel platforms.
-
Extract the archive:
shell> tar zxf mysql-connector-odbc-
3.51.16-osx10.4-x86-32bit.tar.gz -
The directory created contains two subdirectories,
libandbin. Copy these to a suitable location such as/usr/local:shell> cp bin/* /usr/local/bin shell> 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
To install Connector/ODBC 3.51.13 and earlier, follow these steps:
Download the file to your computer and double-click the downloaded image file.
Within the disk image is an installer package (with the
.pkgextension). Double-click on this file to start the Mac OS X installer.-
When you see the installer welcome message, click the button to begin the installation process.
-
Please take the time to read the Important Information as it contains guidance on how to complete the installation process. Once you have read the notice and collected the necessary information, click .
-
Connector/ODBC drivers are made available under the GNU General Public License. Please read the license if you are not familiar with it before continuing installation. Click to approve the license (you will be asked to confirm that decision) and continue the installation.
-
Choose a location to install the Connector/ODBC drivers and the ODBC Administrator application. Install the files onto a drive with an operating system; you may be limited in the choices available. Select the drive you want to use, and then click .
-
The installer automatically selects the files that need to be installed on your machine. Click to continue. The installer copies the necessary files to your machine. A progress bar indicates the installation progress.
-
When installation has been completed, you see a window like the one shown below. Click to close and quit the installer.
User Comments
For OSX 10.6+ ODBC Administrator is a separate download from Apple
Add your own comment.