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
the -lmysqlclient -lz options in the link
command. You may also need to specify a -L
option to tell the linker where to find the library. For
example, if the library is installed in
/usr/local/mysql/lib, use
-L/usr/local/mysql/lib -lmysqlclient -lz in the
link command.
For clients that use MySQL header files, you may need to specify
an -I option when you compile them (for
example, -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:
CFG=/usr/local/mysql/bin/mysql_config
sh -c "gcc -o progname `$CFG --cflags` progname.c `$CFG --libs`"
The sh -c is needed to get the shell not to
treat the output from mysql_config as one
word.
