I am having a problem with mySQL and the C API. I took the example from the mySQL documentation and compiled it. I followed the directions that the docs gave me.

example...
gcc myfile.c -L/usr/lib/mysql -lmysqlclient

I got errors that there is undefined references to my_compress(). The docs say to place a -lz in the gcc line to correct the problem.

gcc myfile.c -L/usr/lib/mysql -lmysqlclient -lz

Problem here is that my linux distro doesn't know what -lz is. What library is libz? I do not have it on my Linux box. I am running Mandrake 8.0 with mySQL that came on the CD (probably not 4.0)

Please help me ... this is driving me crazy!


Thanks!

Download, build and install zlib.

http://www.gzip.org/zlib/