{{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