linux下用C語言寫MySQL程序，用如下命令編譯時(shí)出錯(cuò)：
[xitong@localhost mysql]$ gcc -o mysql mysql.c -lmysqlclient
錯(cuò)誤如下:
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld 返回 1
解決方法：
用locate命令查找mysqlclient所在目錄，如下所示：
[xitong@localhost mysql]$ locate mysqlclient
結(jié)果顯示：
/usr/local/mysql/lib/mysql/libmysqlclient.a
/usr/local/mysql/lib/mysql/libmysqlclient.la
/usr/local/mysql/lib/mysql/libmysqlclient.so
/usr/local/mysql/lib/mysql/libmysqlclient.so.16
/usr/local/mysql/lib/mysql/libmysqlclient.so.16.0.0
/usr/local/mysql/lib/mysql/libmysqlclient_r.a
/usr/local/mysql/lib/mysql/libmysqlclient_r.la
/usr/local/mysql/lib/mysql/libmysqlclient_r.so
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.16
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.16.0.0
編譯時(shí)加入路徑/usr/local/mysql/lib/mysql，如下：
[xitong@localhost mysql]$ gcc -o mysql mysql.c -L/usr/local/mysql/lib/mysql -lmysqlclient
[xitong@localhost mysql]$
編譯通過，問題解決。
再加一點(diǎn)，編譯問題解決了，運(yùn)行的時(shí)候發(fā)現(xiàn)出現(xiàn)如下錯(cuò)誤：
./mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
借用一網(wǎng)友的解決方法，添加環(huán)境變量：
[xitong@localhost mysql]$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/mysql/
再次運(yùn)行編譯好的程序，OK
