mysql_dump_debug_info writes debugging information for the current connection in the logfile of the servers. the user must have administrator rights
return 1 if success 0 otherwise
#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,"username"); sprintf(pass,"password"); 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"); } mysql_dump_debug_info(my); printf("Server-Debug is enabled\n"); mysql_close(my); return 0; }
Login correct Server-Debug is enabled