急问：mysql_real_connect连接出错（bad handshake），请高手帮忙

Question

mysql_init(&mysql);
mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"your_prog_name");
if (!mysql_real_connect(&mysql,"host","user","passwd","database",0,NULL,0))
{
    fprintf(stderr, "Failed to connect to database: Error: %s\n",
          mysql_error(&mysql));
}试试看加上mysql_options()

Answer 1

加上这一句还是不行，我想问一下这一句什么意思，那个your_prog_name是什么？

Answer 2

MYSQL  *ldap_billingd=NULL;
char *dbhost_billing="127.0.0.1";
char *dbuser_billing="root";
char *dbpassword_billing="";
int dbport_billing=3306;
if ((ldap_billingd= mysql_init(NULL))==NULL) 
   {     printf("ldap_billingd: %s",mysql_error(ldap_billingd));   
   }
log("mysql_init is finished! \n");
   if (mysql_real_connect(ldap_billingd,dbhost_billing,dbuser_billing,dbpassword_billing,"test",dbport_billing,NULL,0) <0)
   {
    printf("-----------------ldap_billingd: %s----------------",mysql_error(ldap_billingd));
}
printf("mysql_real_connect is finished! \n");
,"test",是数据库名

Answer 3

mysql_real_connect(&mysql,"localhost","root","dddd","test",0,NULL,0)?????mysql的端口是0吗? 不是的话改成你安装的端口, 默认是3306
例如:
mysql_real_connect(&mysql,"localhost","root","dddd","test", 3306, NULL, 0)

Answer 4

可能是LIBMYSQLCLIENT的版本不对