./configure --with-libdir=lib64 --with-mysql
This is probably obvious to most but I needed to do this to make PHP compile using mysql against the 64 bit header files:
On 64 bit Snow Leopard (Mac OSX) in particular, get the latest version of MySQLdb for Python.
You will then need to make sure you have a 64 bit version of MySQL installed (I installed it from source), and that the /usr/local/src/MySQL-python-1.2.3c1/setup_posix.py file (this is the particular version I have) is using the correct mysql_config. Either make sure your PATH is correct or edit that file (suggested here).
Of course you also need to have the 64 bit version of python installed.
Frustrated users should also read this (note how accurate the article title is).
You will then need to make sure you have a 64 bit version of MySQL installed (I installed it from source), and that the /usr/local/src/MySQL-python-1.2.3c1/setup_posix.py file (this is the particular version I have) is using the correct mysql_config. Either make sure your PATH is correct or edit that file (suggested here).
Of course you also need to have the 64 bit version of python installed.
Frustrated users should also read this (note how accurate the article title is).
If you go to mysql5.0 (same with mysql5.1) you will notice a list of MySQL binaries for Mac OS X. If you are using Leopard (10.5) and you want to compile PHP with MySQL then DO NOT use the 10.5 binary. There is a reason why the 10.4 binary is twice the size of the 10.5 one...it's because the 10.5 binary does not have the dev libraries that allow PHP to compile against it (well, I kept getting the same error message about missing symbols...).
It seems quite bizarre to put these packages together in the same place on the MySQL site as they represent different things.