/*
 gcc csc9641.c -o csc9641 -L/home/sbester/servers/5.0-bk/lib -I/home/sbester/servers/5.0-bk/include  -lmysqlclient -lz
*/
#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <sys/resource.h>
#include "mysql.h"

int main(void)
{
                     
	static char query[]="SELECT @@SQL_BIG_SELECTS";                                       
    MYSQL *m;
  	MYSQL_RES *r;
  	MYSQL_ROW w;
  	MYSQL_FIELD *fields;
    int numfields=0;int numrows=0;  int i=0;
  	m=mysql_init(NULL);
	if(!mysql_real_connect(m,"127.0.0.1", "root", "12345", NULL,3306, NULL, 0))
  	{
  		printf("Cannot connect.");
  		exit(1);
  	}
 	mysql_query(m,query);
  	r= mysql_store_result(m);
  	numrows = mysql_num_rows(r);
  	numfields = mysql_num_fields(r);
  	fields = mysql_fetch_fields(r);
  	printf("Reading SQL_BIG_RESULTS without calling mysql_change_user first:\n\n");
  	numrows=0;
  	while((w = mysql_fetch_row(r)))
  	{
  		printf("Row %d\n",numrows);
  		for(i=0;i<numfields;i++)
  		{
			 printf("Field Name: %s\nField Value: %s\nField Type: %d\n\n",fields[i].name,w[i],fields[i].type);
  		} 
  		numrows++;
  	} 
  	mysql_free_result(r) ;	
  
  	if (mysql_change_user(m, "root", "12345", "mysql"))
	{
   		printf("Failed to change user.  Error: %s\n", mysql_error(m));
	}

	printf("Reading SQL_BIG_RESULTS after calling mysql_change_user first:\n\n");
  	mysql_query(m,query);
  	r= mysql_store_result(m);
  	numrows = mysql_num_rows(r);
  	numfields = mysql_num_fields(r);
  	fields = mysql_fetch_fields(r);
  	numrows=0;
  	while((w = mysql_fetch_row(r)))
  	{
  		printf("Row %d\n",numrows);
  		for(i=0;i<numfields;i++)
  		{
			printf("Field Name: %s\nField Value: %s\nField Type: %d\n\n",fields[i].name,w[i],fields[i].type);
  		} 
  		numrows++;
  	}
  	mysql_free_result(r);	
   	mysql_close(m);
  puts("\n\nFinished.");
}