I had initial problem building 64 bit version. But after changing /usr/lib and /usr/lib/mysql to /usr/lib64 and /usr/lib64/mysql and adding CFLAGS="-g -O2 -m64" Did the trick. I was able to build 64 bit version on FC4. It would be nice if the configure script would support this out of the box when you pass -m64 as part of CFLAGS or some auto detection.
Also to build 32 bit version I have to ls -n /usr/lib/libnetsnmp.so /usr/lib/libnetsnmp.so.5. This fixed the linking.
Still working on making static linking
Also to build 32 bit version I have to ls -n /usr/lib/libnetsnmp.so /usr/lib/libnetsnmp.so.5. This fixed the linking.
Still working on making static linking
Comment