ODBC driver manager is not distributed along with our driver and must be installed separately. ODBC Driver for MySQL is compatible with iODBC driver manager. In case when using other ODBC driver managers, ODBC Driver for MySQL will be installed, but it will require manual modification of configuration files of these managers. Actual Technologies also makes a commercial ODBC driver for MySQL for Mac OS X that works with FileMaker Pro 6 or later. It has an installer, a DSN setup assistant, on-line help, and connection diagnostic tool. Instructions for configuring FMP to work with the driver can be found in the FAQ. A free, non-expiring evaluation version is available.
macOS 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.
On macOS, the ODBC Administrator, based on the iODBC
manager, provides easy administration of ODBC drivers and configuration, allowing the updates of the underlying iODBC
configuration files through a GUI tool. The tool is included in macOS v10.5 and earlier; users of later versions of macOS need to download it from http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads and install it manually.
OpenSSL is a required dependency. The macOS installation binaries bundle OpenSSL, while the compressed tar archives do not and require that you install OpenSSL on your system before the installation process.
There are two ways to install Connector/ODBC on macOS. 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 (some of the steps below might require superuser privileges):
Download the compressed tar archive.
Extract the archive:
The directory created contains two subdirectories,
lib
andbin
. Copy these to a suitable location such as/usr/local
:Finally, register the driver with iODBC using the myodbc-installer tool that was included in the package:
For Connector/ODBC 8.0:
For Connector/ODBC 5.3:
Odbc Mysql For Mac Versions
To install using the a compressed disk image (.dmg
) file:
iODBC 3.52.12 or later must be installed on the macOS system before you can install Connector/ODBC using a compressed disk image. See Section 4.3, 'Installing Connector/ODBC on macOS'.
Download the disk image.
Double click the disk image to open it. You see the Connector/ODBC installer inside.
Double click the Connector/ODBC installer, and you will be guided through the rest of the installation process. You need superuser privileges to finish the installation.
To verify the installed drivers, either use the ODBC Administrator application or the myodbc-installer utility:
To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini
file within the Library/ODBC
directory of the user, or use the ODBC Administrator GUI.
The ODBC Administrator is included in OS X v10.5 and earlier; users of later versions of OS X and macOS need to download and install it manually.
Web site for mac. To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example:
To use ODBC Administrator:
For correct operation of ODBC Administrator, ensure that the
/Library/ODBC/odbc.ini
file used to set up ODBC connectivity and DSNs are writable by theadmin
group. If this file is not writable by this group, then the ODBC Administrator may fail, or may appear to work but not generate the correct entry.There are known issues with the macOS ODBC Administrator and Connector/ODBC that may prevent you from creating a DSN using this method. In that case, use the command line or edit the
odbc.ini
file directly. Existing DSNs or those that you created using the myodbc-installer tool can still be checked and edited using ODBC Administrator.
Open the ODBC Administrator from the
Utilities
folder in theApplications
folder.Since the original media container could contain various data — video, audio, and others — Apple created its own extensions that would allow users to distinguish exactly what content is inside the file. M4A is Apple's modification of MPEG-4 (MP4) media container containing audio files.
Figure 5.7
ODBC Administrator
DialogFrom the
ODBC Administrator
dialog, choose either the User DSN or System DSN tab and click .Select the Connector/ODBC driver and click .
You will be presented with the
Data Source Name
(DSN) dialog. Enter theData Source Name
and an optionalDescription
for the DSN.Figure 5.8
ODBC Administrator Data Source Name
DialogClick to add a new keyword/value pair to the panel. Configure at least four pairs to specify the
server
,username
,password
anddatabase
connection parameters. See Section 5.5.2, 'Connector/ODBC Connection Parameters'.Click to add the DSN to the list of configured data source names.
Odbc Mysql Mac Os X
A completed DSN configuration may look like this:
Mysql Odbc Driver For Mac
Figure 5.9 ODBC Administrator Sample DSN
Dialog
On macOS, the ODBC Administrator, based on the iODBC
manager, provides easy administration of ODBC drivers and configuration, allowing the updates of the underlying iODBC
configuration files through a GUI tool. The tool is included in macOS v10.5 and earlier; users of later versions of macOS need to download it from http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads and install it manually.
OpenSSL is a required dependency. The macOS installation binaries bundle OpenSSL, while the compressed tar archives do not and require that you install OpenSSL on your system before the installation process.
There are two ways to install Connector/ODBC on macOS. 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 (some of the steps below might require superuser privileges):
Download the compressed tar archive.
Extract the archive:
The directory created contains two subdirectories,
lib
andbin
. Copy these to a suitable location such as/usr/local
:Finally, register the driver with iODBC using the myodbc-installer tool that was included in the package:
For Connector/ODBC 8.0:
For Connector/ODBC 5.3:
Odbc Mysql For Mac Versions
To install using the a compressed disk image (.dmg
) file:
iODBC 3.52.12 or later must be installed on the macOS system before you can install Connector/ODBC using a compressed disk image. See Section 4.3, 'Installing Connector/ODBC on macOS'.
Download the disk image.
Double click the disk image to open it. You see the Connector/ODBC installer inside.
Double click the Connector/ODBC installer, and you will be guided through the rest of the installation process. You need superuser privileges to finish the installation.
To verify the installed drivers, either use the ODBC Administrator application or the myodbc-installer utility:
To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini
file within the Library/ODBC
directory of the user, or use the ODBC Administrator GUI.
The ODBC Administrator is included in OS X v10.5 and earlier; users of later versions of OS X and macOS need to download and install it manually.
Web site for mac. To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example:
To use ODBC Administrator:
For correct operation of ODBC Administrator, ensure that the
/Library/ODBC/odbc.ini
file used to set up ODBC connectivity and DSNs are writable by theadmin
group. If this file is not writable by this group, then the ODBC Administrator may fail, or may appear to work but not generate the correct entry.There are known issues with the macOS ODBC Administrator and Connector/ODBC that may prevent you from creating a DSN using this method. In that case, use the command line or edit the
odbc.ini
file directly. Existing DSNs or those that you created using the myodbc-installer tool can still be checked and edited using ODBC Administrator.
Open the ODBC Administrator from the
Utilities
folder in theApplications
folder.Since the original media container could contain various data — video, audio, and others — Apple created its own extensions that would allow users to distinguish exactly what content is inside the file. M4A is Apple's modification of MPEG-4 (MP4) media container containing audio files.
Figure 5.7
ODBC Administrator
DialogFrom the
ODBC Administrator
dialog, choose either the User DSN or System DSN tab and click .Select the Connector/ODBC driver and click .
You will be presented with the
Data Source Name
(DSN) dialog. Enter theData Source Name
and an optionalDescription
for the DSN.Figure 5.8
ODBC Administrator Data Source Name
DialogClick to add a new keyword/value pair to the panel. Configure at least four pairs to specify the
server
,username
,password
anddatabase
connection parameters. See Section 5.5.2, 'Connector/ODBC Connection Parameters'.Click to add the DSN to the list of configured data source names.
Odbc Mysql Mac Os X
A completed DSN configuration may look like this:
Mysql Odbc Driver For Mac
Figure 5.9 ODBC Administrator Sample DSN
Dialog
Odbc Mysql For Mac Installer
You can configure other ODBC options in your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 5.5.2, 'Connector/ODBC Connection Parameters'.