linux-mysql 连接2

//simple_mysql_connect2.c

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

#include <mysql.h>


int main(int argc, char *argv[]){

	MYSQL connection;
	mysql_init(&connection);

	const char* host = "localhost";
	const char* user = "root";
	const char* password = "";
	const char* dbname = "chat";
        if(argc == 2){
          password = argv[1];
        }


	MYSQL*  conn_ptr= mysql_real_connect(&connection ,host, user, password,dbname,0,NULL,0);
	if(conn_ptr){
		printf("Connection succeed!\n");
		mysql_close(&connection);
	}else{
		fprintf(stderr, "Connection failed!\n");
		if(mysql_errno(&connection)){
			fprintf(stderr, "Connection error %d: %s\n", mysql_errno(&connection), mysql_error(&connection));
		}
	}
	return 0;
}

运行：

（输入错误密码）

xx@ubuntu:~/workspace/mysql-test$ g++ -o connection2 simple_mysql_connect2.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient
xx@ubuntu:~/workspace/mysql-test$ ./connection2   error_pswd
Connection failed!
Connection error 1045: Access denied for user 'root'@'localhost' (using password: YES)
（输入正确密码）

xx@ubuntu:~/workspace/mysql-test$ ./connection2  pswd
Connection succeed!