How to Disable SSL Encryption with mysqlclient lib on mysql-commercial-server 8.0.15?

原创

于 2019-07-25 09:37:32 发布

· 266 阅读

0 ·

版权

文章标签：

#Mysql

在使用mysqlclient库操作mysql-commercial-server 8.0.15时，发现握手后的流量被SSL加密。通过在调用mysql_real_connect()之前添加mysql_options()来更改SSL选项，成功实现了禁用SSL加密。参考了MySQL官方文档。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Environment:
mysql-commercial-client-8.0.15-1.1.el7.x86_64.rpm mysql-commercial-devel-8.0.15-1.1.el7.x86_64.rpm mysql-commercial-server-8.0.15-1.1.el7.x86_64.rpm
mysql-commercial-common-8.0.15-1.1.el7.x86_64.rpm mysql-commercial-libs-8.0.15-1.1.el7.x86_64.rpm

Using mysqlclient lib to operate mysql-commercial-server 8.0.15:

	MYSQL *con = mysql_init(NULL);
	
	if(NULL == con)
	{
		fprintf(stderr, "%s\n", mysql_error(con));
		return -1;
	}
		if(NULL == mysql_real_connect(con, "10.21.17.212", "test", "Today1024!", NULL, 0, NULL, 0))
	{
		fprintf(stderr, "%s\n", mysql_error(con));
		printf("-----mysql_real_connect----\n");
		mysql_close(con);
		return -1;
	}
	// ...

However, the traffic I got after handshake is encrypted in SSL which I don’t want.

So I added mysql_options() to change the SSL option before calling mysql_real_connect(). And it works.