Differences

This shows you the differences between two versions of the page.

--- c:mysql:mysql.h:mysql_get_server_info [2013/02/03 20:19]
127.0.0.1 external edit
+++ c:mysql:mysql.h:mysql_get_server_info [2024/02/16 01:12] (current)
@@ Line 1: / Line 1: @@
 ====== mysql_get_server_info ======
 <code c>
+const char *mysql_get_server_info(MYSQL *mysql)
 </code>
 ==== description of mysql_get_server_info ====
-mysql_get_server_info is in work by code-reference.com \\
+returns current remote server information
-if you are faster... don't hasitate and add it
+compile with gcc mysql_get_server_info.c -o mysql_get_server_info `mysql_config –cflags –libs` -Wall
 <code c>
-no example at the moment
+#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: %s\n", mysql_get_server_info(my));
+mysql_close(my);
+return 0;
+}
 </code>
 ===== output of mysql_get_server_info c example =====
-    no example at the moment
+    Login correct
+    Server info: 5.5.29-0ubuntu0.12.04.2

on the occasion of the current invasion of Russia in Ukraine