大网数据广告活动
服务器运维问答

Can't get SSL with self signed CA to work in SQLYog

· 52CE 我爱测

I have a server with mysql. I issued grant all on *.* to 'user'@'%' require ssl; , created ca, key and cert according to this guide . I'm not using client certs. I copied ca.pem to a sandbox and connected to the database from thi…

问题原文

原帖链接 · klutt · CC BY-SA 3.0

I have a server with mysql. I issued grant all on *.* to 'user'@'%' require ssl;, created ca, key and cert according to this guide. I'm not using client certs.

I copied ca.pem to a sandbox and connected to the database from this sandbox, using the command mysql -u user -p -h 192.168.120.78 --ssl-ca=ca.pem and it works like a charm. Without --ssl-ca=ca.pem it does not work, just as expected. Issuing SHOW STATUS LIKE 'SSL_CIPHER'; confirms that encryption is working.

But when I'm trying to connect with SQLYog using the same ca it does not work. I get the error message

Error No. 2026

SSL connection error: self signed certificate

I'm using SQLYog 12.4.2

已采纳解答

原帖链接 · Orphans · CC BY-SA 3.0

After some googling, I found this:

https://forums.webyog.com/forums/search/SSL+self+signed/

The CA-cert and server-cert cannot have the same common name, because this is a vulnerability for man in the middle attacks. Make sure that they differ. The CN for CA can be anything and the CN for server-certs should correspond to their IP or URL or similar.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-08-08)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。