MySQL Notes

MySQL provides Mac OS X installer packages for both the database and odbc driver. Even though normally you install the database on the server and the odbc driver on all the clients, we assume below that the server and client reside on the same computer.

1. Installing MySQL Database Server 5.0

First download the disk image, then run the installer packages and copy the preference pane into /Library/PreferencePanes or ~/Library/PreferencePanes. Use the preference pane to start and stop the server manually, or enable automatic startup.

2. Installing MySQL Connector/ODBC 3.51

First download the disk image, then run the installer package. The installer will add the driver to the ODBC Administrator and create a default data source.

3. Testing the MySQL Installation

Once you have installed the database, load Tests-Database.stp and evaluate:

MySqlDatabaseTest suite run.

The following test cases are expected to fail:

  • MySqlDatabaseTest>>#testFloat

    This test fails because some precision is lost when storing and then retrieving a float value, although values are approximately the same. The problem is in the ODBC driver.

  • MySqlDatabaseTest>>#testDoublePrecision

    This test fails for the same reason as above.

  • MySqlDatabaseTest>>#testTextU01000ToU10FFFF

    This test fails because MySQL supports only the UCS2 character set and not the full range of Unicode characters.

Last modified May 22, 2006.