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; }
Login correct Server Version: 50520