====== mysql_get_server_info ======
const char *mysql_get_server_info(MYSQL *mysql)
==== description of mysql_get_server_info ====
returns current remote server information
compile with gcc mysql_get_server_info.c -o mysql_get_server_info `mysql_config –cflags –libs` -Wall
#include /* including standard library */
#include
MYSQL *my;
int main( void ){
char host[20];
char user[20];
char pass[20];
my = mysql_init(NULL);
sprintf(host,"localhost");
sprintf(user,"user");
sprintf(pass,"pass");
if (my == NULL ) {
printf("Cant initalisize MySQL\n");
return 1;
}
if( mysql_real_connect (my,host,user,pass,NULL,0,NULL,0) == NULL) {
printf("Error cant login\n");
} else {
printf("Login correct\n");
}
printf("Server information: %s\n", mysql_get_server_info(my));
mysql_close(my);
return 0;
}
===== output of mysql_get_server_info c example =====
Login correct
Server info: 5.5.29-0ubuntu0.12.04.2