#include <mysql.h>
#include <stdio.h>
#include <sys/types.h>

int main(int argc, char *argv[])
{
	MYSQL *mysql;
	MYSQL_RES *results;
	MYSQL_ROW record;

static char *server_groups[] = { "libmysqld_server", 
                                 "libmysqld_client", NULL };


	static char *server_args_a[] = {
		"this_program",       /* this string is not used */
		"--datadir=./a",
		"--skip-innodb",
		"--key_buffer_size=32M",
                "--language=mysql-advanced-gpl-5.1.32-linux-x86_64-glibc23/share/english/"
	};

	mysql_library_init(sizeof(server_args_a) / sizeof(char *), server_args_a, NULL);

	mysql = mysql_init(NULL);
	mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
	mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);

	mysql_real_connect(mysql, NULL,NULL,NULL, NULL, 0,NULL,0);
	mysql_query(mysql, "create database testa");

	mysql_query(mysql, "SHOW DATABASES");
	results = mysql_store_result(mysql);
	printf("\n\nDatabases in server a\n");
	while((record = mysql_fetch_row(results)))
	{
		printf("%s\n", record[0]);
	}
	mysql_free_result(results);
	mysql_close(mysql);
	mysql_library_end();
}