CentOS 下搭建 MySQL 的详细步骤，及 C API 编程

最新推荐文章于 2024-07-04 21:42:34 发布

原创最新推荐文章于 2024-07-04 21:42:34 发布 · 445 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#centos #mysql #c语言

sql 同时被 2 个专栏收录

15 篇文章

订阅专栏

Linux

6 篇文章

订阅专栏

1 执行 yum 命令安装 MySQL

yum -y install mysql mysql-server

2 把 MySQL 添加进开机启动项，并立即启动 MySQL

chkconfig --levels 235 mysqld on /etc/init.d/mysqld start

3 打开 mysqld

service mysqld start

4 设置 MySQL root 帐号密码

mysql -u root
>use mysql;
>UPDATE user SET Password=PASSWORD('new_passwd') WHERE User='root';
>FLUSH PRIVILEGES;

5 创建表格

>create database chess_db;
>use chess_db;
>CREATE TABLE account
>(
>id INTEGER auto_increment,
>account VARCHAR(32) NOT NULL,
>password VARCHAR(128) NOT NULL,
>name VARCHAR(32) NOT NULL,
>PRIMARY KEY (id),
>UNIQUE KEY (account)
>);

5 安装 C API 库及头文件

yum install mysql-devel

6 运行测试程序

// main.c
#include <mysql.h>
#include <stdio.h>
#include <string.h>

void testConnectDB();

int main()
{
    testConnectDB();

    return 0;
}

void testConnectDB()
{
    MYSQL *connection;
    MYSQL_STMT *stmt;

    connection = mysql_init(NULL);
    if (connection == NULL)
    {
        perror("mysql_init");
        return;
    }

    stmt = mysql_stmt_init(connection);
    if (NULL == stmt)
    {
        perror("mysql_stmt_init");
        return;
    }

    connection = mysql_real_connect(connection, "localhost", "root", "root123", "chess_db", 0, NULL, 0);
    if (connection == NULL)
    {
        perror("mysql_real_connect");
        return;
    }

    if (mysql_query(connection, "set names gbk"))
    {
        fprintf(stderr, "%d: %s\n", mysql_errno(connection), mysql_error(connection));
    }

    char sql[] = "INSERT INTO account(account,password,name) VALUES(?,PASSWORD(?),?)";
    mysql_stmt_prepare(stmt, sql, (unsigned long)strlen(sql));

    char param_1[32] = "xgiton@qq.com";
    char param_2[128] = "1234567";
    char param_3[32] = "xgiton";

    MYSQL_BIND params[3];
    memset(params, 0, sizeof(params));

    params[0].buffer_type = MYSQL_TYPE_STRING;
    params[0].buffer = param_1;
    params[0].buffer_length = (unsigned long)strlen(param_1);

    params[1].buffer_type = MYSQL_TYPE_STRING;
    params[1].buffer = param_2;
    params[1].buffer_length = (unsigned long)strlen(param_2);

    params[2].buffer_type = MYSQL_TYPE_STRING;
    params[2].buffer = &param_3;
    params[2].buffer_length = (unsigned long)strlen(param_3);

    mysql_stmt_bind_param(stmt, params);
    mysql_stmt_execute(stmt);
    mysql_stmt_close(stmt);
    mysql_close(connection);
}

运行命令

gcc -o start main.c -L /usr/lib64/mysql -I /usr/include/mysql -lmysqlclient
./start

查看数据库就可以看到运行结果啦。