Table of Contents

mysql_get_server_version

unsigned long mysql_get_server_version(MYSQL *mysql)

description of mysql_get_server_version

mysql_get_server_version() returns the current version of your mysql client usualy returns the number in the following format XXYYZZ XX mainversion
YY release level
ZZ current version number

compile with gcc mysql_get_server_version.c -o mysql_get_server_version `mysql_config –cflags –libs` -Wall

#include <stdio.h> /* including standard library */ 
#include <mysql/mysql.h>
 
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: %li\n", mysql_get_server_version(my));
 
mysql_close(my);
return 0;
}

output of mysql_get_server_version c example

  Login correct
  Server Version: 50520