accessing mysql database through c

sonika_singhi · 12-10-2004, 04:14 AM

how to compile a c program accessing mysql database.
what is the need to pass path of library files with gcc cmd while compiling.how to run the file? we have written whole c prog with necessary functions, but don't know how to run. ./a.out doesn't work.
hoping for reply,
please help!

Hko · 12-10-2004, 11:27 AM

Did you try:

gcc -lmysqlclient -o .... ....

?

sonika_singhi · 12-12-2004, 12:39 PM

yes we have tried with the option gcc -lmysqlclient..... but getting errors after this
don't know what to do?
is this mysqlclient the library file
pls specify from the beginning.
we are using this mysql with c for the first time, it is relevant to our project
hoping for reply

Mara · 12-12-2004, 02:35 PM

Errors probably means you don't have the library or its headers. Check if you have mysql-devel package installed.

btmiller · 12-12-2004, 03:19 PM

You may also need to pass -L <directory with MySQL library> if libmysqlclient is not in one of the standard library directories. You can figure out where it is for sure by typing "locate libmysqlclient" at a command prompt.

rajesh_b · 12-15-2004, 09:37 AM

In order to interface to mysql u must install developement libraires corresponding to the version of mysql installed on u r system. After u have installed i think the following command can be used to compile the prog

gcc `mysql_config --libs --cflags` progname.c