As far as I know, there are no C API changes in MySQL-5.0 relative to 4.1, so it should just work. Install MySQL-5.0.3, build MySQL-python, report your results. You can probably use the 4.1 client library with the 5.0 server without any difficulties.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a way to buile the last release of mysql-python against the libraries of MySQL 5.0? I am really looking at just evaluating MySQL 5.
Cheers!
I have tried to do so with win2k, vcc6, mysql-5.0.16, python-2.3.5, mysql-python.1.20.
The same mysqlclient_r problem came; compiling with mysqlclient yields numerous errors like this:
'''libcmt.lib(dosmap.obj) : error LNK2005: __errno already defined'''.
AFAIK, this is due to mix of single- and multy-threaded libs.
However, mysql5 doc states, that "the Windows binaries are by default compiled to be thread-safe", see http://dev.mysql.com/doc/refman/5.0/en/threaded-clients.html
As far as I know, there are no C API changes in MySQL-5.0 relative to 4.1, so it should just work. Install MySQL-5.0.3, build MySQL-python, report your results. You can probably use the 4.1 client library with the 5.0 server without any difficulties.