linux 下链接mysql练习

编译命令如下
hzz@hzz-pc:~/code/testCode$ g++ -I /usr/include/mysql/ /home/hzz/code/testCode/connect2.c -L /usr/lib/mysql -lmysqlclient -o connection2
hzz@hzz-pc:~/code/testCode$ ./connection2

#include <stdlib.h>
#include <stdio.h>
#include "mysql.h"

int main(int argc,char *arg[])
{
  MYSQL myconnection;
  mysql_init(&myconnection);
  if(mysql_real_connect(&myconnection,"localhost","test","test","testDb1",0,NULL,0))
    {

      printf("connection success");
      mysql_close(&myconnection);
    }
  else
    {
      fprintf(stderr,"connection failed\n");
      if(mysql_errno(&myconnection))
      {
          fprintf(stderr,"Connection error %d %s",mysql_errno(&myconnection),mysql_error(&myconnection));
      }
     }

 return 0;
}