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

int main(int argc, char **argv) {
	MYSQL *mysql;
        MYSQL_RES *res;
        MYSQL_ROW row;
	
	mysql = 0;


	mysql = mysql_init(mysql);

	mysql_real_connect(mysql,"127.0.0.1","root",0,0,0,0,0);
        mysql_select_db(mysql,"test");
        mysql_query(mysql, "CREATE TEMPORARY TABLE bar (id int)");
        mysql_change_user(mysql,"localhost","root","test");

	mysql_query(mysql,"CREATE TEMPORARY TABLE foo (id int)");
        mysql_query(mysql,"INSERT INTO foo VALUES (5);");
        sleep(30);
	exit(0);
}