centos 7 下 C语言连接MYSQL

先安装MYSQL，一切操作在root用户下

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
#rpm -ivh mysql-community-release-el7-5.noarch.rpm
#yum install mysql-community-server

上面三条命令完成安装。
//密码请自己设置。

安装mysql 支持包：
#yum search mysql

Loaded plugins: langpacks
============================== ==============================

mysql-community-devel.x86_64 : Development header files and libraries for MySQL

找到一个这样描述的包。

#yum install mysql-community-devel.x86_64

下面是连接代码：

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

#include<mysql/mysql.h>

int main()
{
        MYSQL *conn;
        conn = mysql_init(NULL);
        if(!conn)
        {
                fprintf(stderr,"mysql_init failed!\n");
                return -1;
        }
        conn = mysql_real_connect(conn,"localhost","root","123456","test",0,NULL,0);
        if(conn)
        {
                printf("connection succeed!\n");
        }
        else{
                printf("connection failed!\n");
                return -2;
        }
        mysql_close(conn);
        printf("connection close!\n");
        return 0;
}

编译命令：#gcc $(mysql_config --cflags) connMysql.c -o conn$(mysql_config –libs)

执行：#./test

完成。