I've installed MySQL on my system and I'm trying to make a C program that interacts with MySQL, but I just can't figure out what my problem is. Here is the error message I get:

Ld "build/Debug/C Cmd" normal x86_64
cd "/Users/acbarberi/Projects/C Cmd"
setenv MACOSX_DEPLOYMENT_TARGET 10.6
/Developer/usr/bin/gcc-4.2 -arch x86_64 -isysroot /Developer/SDKs/MacOSX10.6.sdk "-L/Users/acbarberi/Projects/C Cmd/build/Debug" -L/users/acbarberi/mysqlcode/include -L/users/acbarberi/mysqlcode/lib "-F/Users/acbarberi/Projects/C Cmd/build/Debug" -filelist "/Users/acbarberi/Projects/C Cmd/build/C Cmd.build/Debug/C Cmd.build/Objects-normal/x86_64/C Cmd.LinkFileList" -mmacosx-version-min=10.6 -o "/Users/acbarberi/Projects/C Cmd/build/Debug/C Cmd"

Undefined symbols:
"_mysql_close", referenced from:
_main in main.o
"_mysql_init", referenced from:
_main in main.o
ld: symbol(s) not found
collect2: ld returned 1 exit status

I figured it out.

1) In Xcode with your project open, go to Project...Edit Project Settings

2) Open the Build tab.

3) In the search box type, "Other Linker Flags"

4) Add these flags: -lmysqlclient -lm -lz


That fixed it for me!