Linux 下 C++ 连接 MySQL

环境： Ubuntu 16.0.4

编译器： CLion

 

1. 下载安装 MySQL  https://dev.mysql.com/downloads/mysql/5.6.html#downloads

2. 将MySQL 根目录下的 lib  include  文件复制到工程中

                           

3. 在CMakeLists 中添加 so连接库以及include 头文件

set_directory_properties(mysql)

link_libraries("/root/CLionProjects/mysql-test/mysql/lib/libmysqlclient.so")

4. 编写main.cpp

#include <iostream>
#include "mysql/include/mysql.h"

void query_sql(char* sql);

void query_sql(char* sql)
{
    MYSQL conn;
    int res;
    mysql_init(&conn);
    if(mysql_real_connect(&conn,"127.0.0.1","root","123456","database_name",3306,NULL,0))
    {
        printf("connect success!\n");
        res=mysql_query(&conn,sql);
        if(res)
        {
            printf("error\n");
        }
        else
        {
            printf("OK\n");
        }
        mysql_close(&conn);
    } else{
        printf("connect failed!\n");
    }
}

int main(int argc,char *argv[]) {
    query_sql("select * from test");
    return 0;
}

5. run