/* PROGRAM NAME : LC102_main.c */
/* AUTHOR       : ymlib.com    */
/* MAKE DAY     : 2009/05/18   */

/*             */
/* MySQLへ接続 */
/*             */

#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>

int main( int argc, char** argv )
{
    char* db_host = "localhost";
    char* db_name = "ymdb";
    char* db_user = "ymusr";
    char* db_pass = "ympass";
    int   db_port = 0;
    char* db_sock = NULL;

    MYSQL* mysql;
    MYSQL* con;

    // 初期化
    mysql = mysql_init( NULL );
    if ( mysql == NULL )
    {
        printf( "mysql_init error!!\n");
        exit( 1 );
    }

    // MySQLへ接続
    con = mysql_real_connect( mysql
                            , db_host
                            , db_user
                            , db_pass
                            , db_name
                            , db_port
                            , db_sock
                            , 0
                            );
    if ( con == NULL )
    {
        printf( "mysql_real_connect error!!\n" );
        exit( 2 );
    }

    printf( "MySQL Connect OK!!\n" );

    // MySQLから切断
    mysql_close( mysql );

    return ( 0 );
}