This shows you the differences between two versions of the page.
c:mysql:mysql.h:mysql_real_connect [2013/01/22 22:02] |
c:mysql:mysql.h:mysql_real_connect [2024/02/16 01:12] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{keywords>wiki library source code example reference}} | ||
+ | ====== mysql_real_connect ====== | ||
+ | |||
+ | <code c> | ||
+ | #include <mysql/mysql.h> | ||
+ | MYSQL *mysql_real_connect( MYSQL *mysql, | ||
+ | const char *host, | ||
+ | const char *user, | ||
+ | const char *password, | ||
+ | const char *database, | ||
+ | unsigned int port, | ||
+ | const char *unix_socket, | ||
+ | unsigned int client_flag ); | ||
+ | </code> | ||
+ | |||
+ | |||
+ | ===== C Sourcecode Example ===== | ||
+ | Compile with: gcc mysql.c -o mysql **-lmysqlclient** | ||
+ | |||
+ | <code c> | ||
+ | |||
+ | #include <stdio.h> /* including standard library */ | ||
+ | //#include <windows.h> /* uncomment this for Windows */ | ||
+ | |||
+ | #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,"root"); | ||
+ | sprintf(pass,"yourpass"); | ||
+ | |||
+ | 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_close(my); | ||
+ | return 0; | ||
+ | } | ||
+ | </code> | ||
+ | |||
+ | ==== output ==== | ||
+ | |||
+ | user@host:~$ ./mysql | ||
+ | Error cant login | ||
+ | |||
+ | user@host:~$ ./mysql | ||
+ | Login correct | ||