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

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

    const char *server = "mysql";
    #define user "atk4_test_user"
    const char *password = "atk4_pass";
    const char *password_root = "atk4_pass_root";
    const char *database = "atk4_test";

    conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, server, "root", password_root, database, 0, NULL, 0)) {
        fprintf(stderr, "Connect error: %s\n", mysql_error(conn));
        exit(1);
    }
    if (mysql_query(conn, "ALTER USER '" user "'@'\%' WITH MAX_USER_CONNECTIONS 2;")) {
        fprintf(stderr, "Query error: %s\n", mysql_error(conn));
        exit(1);
    }
    mysql_close(conn);

    for (int i = 0; i < 5 * 1000 * 1000; i++) {
        if ((i % 1000) == 0) {
            fprintf(stdout, "iter: %ik\n", i / 1000);
            fflush(stdout);
        }

        conn = mysql_init(NULL);
        if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
            fprintf(stderr, "Connect error: %s\n", mysql_error(conn));
            exit(1);
        }

        mysql_close(conn);
    }
}