MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

MySQL Connector ODBC

with 5 comments

The following are the screen shots for installing MySQL Connector/ODBC, but don’t install this if you’re trying to connect Excel 2011 to MySQL on the Mac OS X because it won’t work. You must install OpenLink Software or Actual Technologies ODBC products because they’ve got special hooks (APIs) required by Excel 2011.

If you’re installing them to use the ODBC for other purposes, here are the screen shots. These steps install MySQL Connector/ODBC 5.1 package:

  1. Launch the MySQL Connector ODBC 5.1 package from the download folder.

Install MySQL Mac ODBC Install Screen Shot #1

  1. Start the MySQL Connector/ODBC 5.1.8 Installer by clicking on the Continue button.

Install MySQL Mac ODBC Install Screen Shot #2

  1. You may want to read the information because it explains what the installer performs. Click the Continue button to proceed with the installation.

Install MySQL Mac ODBC Install Screen Shot #3

  1. This is the GNU License, which you may read or skip. Click the Continue button to proceed with the installation.

Install MySQL Mac ODBC Install Screen Shot #4

  1. Confirm that you agree with the license agreement by clicking the Agree button.

Install MySQL Mac ODBC Install Screen Shot #5

  1. Click the Change Install Location… to install the product somewhere other than the default. Click the Install button to continue with the installation.

Install MySQL Mac ODBC Install Screen Shot #6

  1. You get prompted for the Administrator password. Enter the values and click the OK button.

Install MySQL Mac ODBC Install Screen Shot #7

  1. Click the Close button and the install is complete.

Install MySQL Mac ODBC Install Screen Shot #8

Written by maclochlainn

February 26th, 2011 at 8:34 pm

Posted in Uncategorized

5 Responses to 'MySQL Connector ODBC'

Subscribe to comments with RSS or TrackBack to 'MySQL Connector ODBC'.

  1. […] MySQL Connector/ODBC didn’t work […]

  2. There is a solution for Excel 2011 under OSX 10.7.x Lion… Try the Lunatics! MySQL Connector which is right now free of charge. There is no need to buy a driver. Please read http://www.lunatics.de/?p=989 for further information and download. The Lunatics! connector provides the intended connection from Excel 2011 to a MySQL 5.1.x database.

    Kind regards,
    Robert.

    Robert

    21 Dec 11 at 1:46 am

  3. I have got Excel 2011 under Mavericks to talk to MySQL, using only freely available software…

    (1) Get iODBC (as this includes the crucial CFM connector that lets Excel talk to the ODBC DSNs) (http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X)
    (2) Get the MySQL Connector/ODBC package (the 32 bit version, IIRC).

    I configured my DSN using the ODBC Administrator tool so that I didn’t need to enter username, password, or database name.

    Then it just works in Excel.

    Russ

    8 Oct 14 at 12:14 pm

  4. Russ, Awesome news! Thanks.

    maclochlainn

    14 Oct 14 at 12:07 pm

  5. Is there any change with Excel 2016?

    Bo

    21 Sep 15 at 4:37 pm

Leave a Reply