c语言如何连接mysql数据库

#include <mysql.h>

int main() {
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;

    conn = mysql_init(NULL);
    if (conn == NULL) {
        printf("MySQL initialization failed!\n");
        return 1;
    }

    if (mysql_real_connect(conn, "localhost", "username", "password", NULL, 0, NULL, 0) == NULL) {
        printf("Failed to connect to MySQL: %s\n", mysql_error(conn));
        mysql_close(conn);
        return 1;
    }

    if (mysql_query(conn, "SELECT * FROM table")) {
        printf("Failed to execute query: %s\n", mysql_error(conn));
        mysql_close(conn);
        return 1;
    }

    res = mysql_store_result(conn);
    if (res == NULL) {
        printf("Failed to get result set: %s\n", mysql_error(conn));
        mysql_close(conn);
        return 1;
    }

    while ((row = mysql_fetch_row(res))) {
        printf("%s %s\n", row[0], row[1]);
    }

    mysql_free_result(res);
    mysql_close(conn);

    return 0;
}