MySQL linker error while compiling using Cygwin

Mass Zero · #1 (**permalink**) 01-31-07, 05:15 PM

Hey people,

I made a simple application that Initializes a MySQL connection and shuts it down again. Though, I'm getting some nasty linker errors while compiling. I've searched around the whole frickin' net for the answer and it also comes closer in bits and pieces, but not close enough.

There errors I get while compiling are all in the form of undefined reference to `_mysql_<function>_'.

On several sites it was said I have to add -L<path to my libmysqlclient.so> -lmysqlclient, but it seems as if I don't have that file at all. And it just doesn't seem like that, I don't have the file, while I definitely installed MySQL.

Anyone have the solution for me? It'd be greatly appreciated.

grafman · #2 (**permalink**) 02-01-07, 01:15 AM

Mass Zero,

I love Cygwin!

Anyway, which download did you get your cygwin from? Make sure that you use one like the nasa site or xmission.com. They have all of the libraries that you need to build mysql clients.

If you don't find it there, then use your setup.exe to uninstall mysql that comes with your cygwin and go get the downloads from the mysql site. You could just go get that library but make very sure that your versions match. Its not always intuitive what goes with what so read the release notes on the mysql site for library versions.

The error you are getting says that you don't have the client library in the link chain and so when the linker tries to find the instruction set it isn't there and barfs all over you.

Mass Zero · #3 (**permalink**) 02-01-07, 05:39 AM

Well, I the MySQL I currently use already is a seperate installation. It's not a MySQL I got with the Cygwin installation. (I can't even find any MySQL stuff in the Cygwin packages list.)

grafman · #4 (**permalink**) 02-01-07, 10:26 AM

When you get cygwin you not all of the mirrors have all of the things you need. The most complete is xmission. They have EVERYTHING including postgresql and all of the client libs for both.

So you need to find a complete installation of mysql to solve your problem.

http://mirrors.xmission.com/cygwin/

In the mirror selector you don't get the one that has the cygwin extension. Go here and get this one.