无法编译MYSQL C代码，哪里出错了？是不是MYSQL没有装好？

Ahdong

开始学习LINUX C编程，写了段查询MYSQL的程序老编不过去，不知道是哪儿的问题？在公司RH AS上就可以，那个上面MYSQL应该是系统自带的老版本的。

自己机器上MYSQL是mysql-max-5.0.27-linux-i686-glibc23.tar.gz

下面三段出错代码分别是三条命令的结果 ，代码第一行是命令。

1. 
   
2. 
   
3. gcc -g  -o mycreate mycreate.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
   
4. /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc':my_compress.c:(.text+0xc5)：对‘compress’未定义的引用
   
5. /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress':my_compress.c:(.text+0x14c)：对‘uncompress’未定义的引用
   
6. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::(anonymous namespace)::DiscreteLogWorkFactor(unsigned int)':dh.cpp:(.text+0x8c)：对‘pow’未定义的引用
   
7. :dh.cpp:(.text+0xa6)：对‘log’未定义的引用
   
8. :dh.cpp:(.text+0xae)：对‘pow’未定义的引用
   
9. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::DH::GenerateKeyPair(TaoCrypt::RandomNumberGenerator&, unsigned char*, unsigned char*)':dh.cpp:(.text+0x2d1)：对‘pow’未定义的引用
   
10. :dh.cpp:(.text+0x2ee)：对‘log’未定义的引用
    
11. :dh.cpp:(.text+0x2f6)：对‘pow’未定义的引用
    
12. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::DH::GeneratePrivate(TaoCrypt::RandomNumberGenerator&, unsigned char*)':dh.cpp:(.text+0x488)：对‘pow’未定义的引用
    
13. :dh.cpp:(.text+0x4a9)：对‘log’未定义的引用
    
14. :dh.cpp:(.text+0x4b1)：对‘pow’未定义的引用
    
15. collect2: ld returned 1 exit status
    
16. 
    

复制代码

1. 
   
2. gcc -g  -o mycreate mycreate.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz
   
3. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::(anonymous namespace)::DiscreteLogWorkFactor(unsigned int)':dh.cpp:(.text+0x8c)：对‘pow’未定义的引用
   
4. :dh.cpp:(.text+0xa6)：对‘log’未定义的引用
   
5. :dh.cpp:(.text+0xae)：对‘pow’未定义的引用
   
6. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::DH::GenerateKeyPair(TaoCrypt::RandomNumberGenerator&, unsigned char*, unsigned char*)':dh.cpp:(.text+0x2d1)：对‘pow’未定义的引用
   
7. :dh.cpp:(.text+0x2ee)：对‘log’未定义的引用
   
8. :dh.cpp:(.text+0x2f6)：对‘pow’未定义的引用
   
9. /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-dh.o): In function `TaoCrypt::DH::GeneratePrivate(TaoCrypt::RandomNumberGenerator&, unsigned char*)':dh.cpp:(.text+0x488)：对‘pow’未定义的引用
   
10. :dh.cpp:(.text+0x4a9)：对‘log’未定义的引用
    
11. :dh.cpp:(.text+0x4b1)：对‘pow’未定义的引用
    
12. collect2: ld returned 1 exit status
    
13. 
    

复制代码

1. 
   
2. gcc -g  -o mycreate mycreate.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lm
   
3. /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc':my_compress.c:(.text+0xc5)：对‘compress’未定义的引用
   
4. /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress':my_compress.c:(.text+0x14c)：对‘uncompress’未定义的引用
   
5. collect2: ld returned 1 exit status
   

复制代码

程序代码如下：

1. 
   
2. 
   
3. #include <stdio.h>
   
4. #include <stdlib.h>
   
5. #include <string.h>
   
6. //#include "mysql/mysql.h"
   
7. #include "mysql.h"
   
8. 
   
9. int main()
   
10. {
    
11.         MYSQL *ssock;
    
12.         char sql[500];
    
13.         MYSQL_RES *sel_result = NULL;
    
14.         int i;
    
15.        
    
16.         ssock = (MYSQL *)malloc(sizeof(MYSQL));
    
17.         mysql_init(ssock);
    
18.         if (!(mysql_real_connect(ssock,"localhost","root","eaps0543","test_woody",0,NULL,0)))
    
19.         {
    
20.                 printf("Cannot connect to the mysql server.Error: %s\n",mysql_error(ssock));
    
21.                 exit(-1);
    
22.         }
    
23.        
    
24.         sprintf(sql,"SELECT * FROM girls LIMIT 10");
    
25.        
    
26.         i = mysql_real_query(ssock,sql,strlen(sql));
    
27.        
    
28.         sel_result = mysql_store_result(ssock);
    
29.        
    
30.         while(sel_result->data_cursor)
    
31.         {
    
32.                 printf("Name:%10s,age:%d\n",
    
33.                                 sel_result->data_cursor->data[1],
    
34.                                 atoi(sel_result->data_cursor->data[2]));
    
35.                
    
36.                 sel_result->data_cursor = sel_result->data_cursor->next;
    
37.         }
    
38.        
    
39.         printf("\n\t\t%d records affected\n",sel_result->row_count);
    
40.         mysql_free_result(sel_result);
    
41.         return 0;
    
42.        
    
43. }
    
44. 
    
45. 
    

复制代码

Ahdong

已解决，安装了libmysqlclient15-dev包。