很楠不爱3

这个屌丝很懒，什么也没留下！

热门标签

mysql+禁用ssl连接,如何在MySQL社区服务器上禁用SSL插件？ [关闭]

作者：很楠不爱3 | 2024-05-01 12:08:40

踩

c++ mysql_real_connect 禁用ssl

Closed. This question is off-topic。它目前不接受答案。

想改进这个问题吗？Update the question所以堆栈溢出的值小于aa>。

三年前关闭。

MySQL服务器上新引入的SSL连接现在默认安装在CentOS 6.7 default rep上。

只要删除证书文件就可以根据文档解决问题：

如果服务器在数据目录中找不到有效的证书和密钥文件，它将继续执行，但不启用安全连接

参考：on-topic

但是我想完全禁用mysql服务器上的SSL连接插件，因为我想通过删除所有我不使用的东西来优化mysql服务器的性能，包括这个插件。

如何在MySQL社区服务器上禁用ssl？

最佳答案：

我的测试：$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.12 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE '%ssl%';

+---------------+-----------------+

| Variable_name | Value |

+---------------+-----------------+

| have_openssl | YES |

| have_ssl | YES |

| ssl_ca | ca.pem |

| ssl_capath | |

| ssl_cert | server-cert.pem |

| ssl_cipher | |

| ssl_crl | |

| ssl_crlpath | |

| ssl_key | server-key.pem |

+---------------+-----------------+

9 rows in set (0.00 sec)

文件：/路径/to/File/my.cnf

[mysqld]

...

skip_ssl

# disable_ssl

...

$ service mysql restart

$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.12 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE '%ssl%';

+---------------+----------+

| Variable_name | Value |

+---------------+----------+

| have_openssl | DISABLED |

| have_ssl | DISABLED |

| ssl_ca | |

| ssl_capath | |

| ssl_cert | |

| ssl_cipher | |

| ssl_crl | |

| ssl_crlpath | |

| ssl_key | |

+---------------+----------+

9 rows in set (0.00 sec)

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/很楠不爱3/article/detail/518779