我已经将
MySql配置为使用SSL,它在
PHP中运行良好.但是,当我尝试使用C/C++程序连接到数据库时,它不起作用.
变量:
host = "localhost"
psw = "pass"
db = "database"
没有SSL:
usr = "userNOSSL"
conn = mysql_init(NULL);
mysql_real_connect(conn, host, usr, psw, db, 0, NULL, 0);
这个效果很好.我可以轻松地检索数据:
query = "SELECT x FROM y"
mysql_query(conn, query);
result = mysql_store_result(conn);
num_fields = mysql_num_fields(result);
while ((row = mysql_fetch_row(result)))
{
for(i = 0; i < num_fields; i++)
{
printf("%s ", row[i] ? row[i] : "NULL");
}
printf("\n");
}
mysql_free_result(result);
使用SSL(CLIENT_SSL标记):
usr = "