25.2.14. Building Client Programs
If you compile MySQL clients that you've written yourself or
that you obtain from a third-party, they must be linked using
-lmysqlclient -lz options in the link
command. You may also need to specify a
option to tell the linker where to find the library. For
example, if the library is installed in
-L/usr/local/mysql/lib -lmysqlclient -lz in the
For clients that use MySQL header files, you may need to specify
-I option when you compile them (for
-I/usr/local/mysql/include), so that
the compiler can find the header files.
To make it simpler to compile MySQL programs on Unix, we have
provided the mysql_config script for you. See
Section 25.9.2, “mysql_config — Get Compile Options for Compiling Clients”.
You can use it to compile a MySQL client as follows:
sh -c "gcc -o progname `$CFG --cflags` progname.c `$CFG --libs`"
sh -c is needed to get the shell not to
treat the output from mysql_config as one