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

int main(int argc, char **argv)
{
	// connect to "test" database  
	static char *server_args[] = {
		"this_program",       /* this string is not used */
		"--datadir=.",
		"--key_buffer_size=32M",
		"--skip-innodb"
	};

	static char *server_groups[] = {
		"embedded",
		"server",
		"this_program_SERVER",
		(char *)NULL
	};

  int status;

	printf("round 1\n");

	status = mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups);

  if (status) {
		printf(" mysql_server_init() failed: %d\n", status);
		exit(3);
	}

	// connect to "test" database on "localhost" as "root" 
	MYSQL *mysql = mysql_init(NULL);
	if (! mysql_real_connect(mysql, "localhost", "root", "", "test", 0, NULL, 0 ))
	{
		printf(" mysql_real_connect() failed\n");
		exit(3);
	}
	mysql_close(mysql);
	
  mysql_server_end();

	printf("round 2\n");

	status = mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups);

	// connect to "test" database on "localhost" as "root" 
	if (! mysql_real_connect(mysql, "localhost", "root", "", "test", 0, NULL, 0 ))
	{
		printf(" mysql_real_connect() failed\n");
		exit(3);
	}
	
  mysql_server_end();

	// all done
	printf("all done\n");
	exit(0);
}