The setup.py script uses mysql_config to find all compiler and linker options, and should work as is on any POSIX-like platform, so long as mysql_config is in your path.
Depending on which version of MySQL you have, you may have the option of using three different client libraries:
mysqlclient_r is used by default. To use one of the others, set the environment variable mysqlclient to the name of the library you want to use. In a Bourne-style shell, use:
$ export mysqlclient=mysqlclient
Only do this if you don't have the thread-safe library (mysqlclient_r) or you want to use the embedded server (mysqld).
Finally, putting it together:
$ tar xfz MySQL-python-1.1.10.tar.gz $ cd MySQL-python-1.1.10 $ python setup.py build $ su # or use sudo # python setup.py install
NOTE: You must export environment variables for setup.py to see them. Depending on what shell you prefer, you may need to use "export" or "set -x" (bash and other Bourne-like shells) or "setenv" (csh-like shells).
I don't do Windows. However if someone provides me with a package for Windows, I'll make it available. Don't ask me for help with Windows because I can't help you.
Generally, though, running setup.py is similar to above:
C:\...> python setup.py install C:\...> python setup.py bdist_wininst
The latter example should build a Windows installer package, if you have the correct tools. In any event, you must have a C compiler. Additionally, you have to set an environment variable (mysqlroot) which is the path to your MySQL installation. In theory, it would be possible to get this information out of the registry, but like I said, I don't do Windows, but I'll accept a patch that does this.
If you are using a binary package of Zope, you need run setup.py with the python executable that came with Zope. Otherwise, you'll install into the wrong Python tree and Zope (ZMySQLDA) will not be able to find _mysql.
With zope.org's Zope-2.5.1-linux2-x86 binary tarball, you'd do something like this:
$ export ZOPEBIN=".../Zope-2.5.1-linux2-x86/bin" # wherever you unpacked it $ $ZOPEBIN/python setup.py install # builds and installs
I don't plan to make binary packages any more. However, if someone contributes one, I will make it available. Several OS vendors have their own packages available.
If you prefer to install RPMs, you can use the bdist_rpm command with setup.py. This only builds the RPM; it does not install it. You may want to use the --python=XXX option, where XXX is the name of the Python executable, i.e. python, python2, python2.1; the default is python. Using this will incorporate the Python executable name into the package name for the RPM so you have install the package multiple times if you need to support more than one version of Python.
MySQL-python is pre-packaged in Red Hat Linux 7.x and newer. This likely includes Fedora Core and Red Hat Enterprise Linux. You can also build your own RPM packages as described above.
Packaged as mysql-python. Gentoo is also my development platform:
# emerge sync # emerge mysql-python # emerge zmysqlda # if you use Zope
MySQL-python is a ported package in FreeBSD, NetBSD, and OpenBSD, although the name may vary to match OS conventions.