[...]
Change the password
for
root ? ((Press y|Y
for
Yes, any other key
for
No) : y
New password:*******
Re-enter new password:*******
[...]
Do you wish to
continue
with the password provided?(Press y|Y
for
Yes, any other key
for
No) : y
[...]
Remove anonymous
users
? (Press y|Y
for
Yes, any other key
for
No) : y
[...]
Disallow root login remotely? (Press y|Y
for
Yes, any other key
for
No) :
[...]
Remove
test
database and access to it? (Press y|Y
for
Yes, any other key
for
No) : y
[...]
Reload privilege tables now? (Press y|Y
for
Yes, any other key
for
No) : y
[...]
+----------------------------+----------+--------------------+----------------------+---------+
| Name | Status | Type | Library | License |
+----------------------------+----------+--------------------+----------------------+---------+
| validate_password | DISABLED | VALIDATE PASSWORD | validate_password.so | GPL |
+----------------------------+----------+--------------------+----------------------+---------+
45 rows
in
set
(0.00 sec)
+---------------+---------------+
| Variable_name | Value |
+---------------+---------------+
| tls_version | TLSv1,TLSv1.1 |
+---------------+---------------+
1 row
in
set
(0.00 sec)
mysql -uroot -p
grant all privileges on *.* to scm@
'hd01.cmdschool.org'
identified by
'scm'
require none;
grant all privileges on *.* to scm@
'hd02.cmdschool.org'
identified by
'scm'
require ssl;
flush privileges;
+------+--------------------+----------+
| user | host | ssl_type |
+------+--------------------+----------+
| scm | hd01.cmdschool.org | |
| scm | hd02.cmdschool.org | ANY |
+------+--------------------+----------+
2 rows
in
set
(0.00 sec)
注：帐号“scm@hd01.cmdschool.org”不强制使用SSL链接而“scm@hd02.cmdschool.org”被强制使用SSL链接，不使用SSL无法登陆。
2.2.7 登录测试
1) 使用SSL链接
In hd02
Current user: scm@HD02.cmdschool.org
SSL: Cipher
in
use is DHE-RSA-AES256-SHA
Current pager: stdout
Using outfile:
''
Using delimiter: ;
Server version: 5.7.18-log MySQL Community Server (GPL)
Protocol version: 10
Connection: hd01.cmdschool.org via TCP
/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 12 min 51 sec
Threads: 6 Questions: 1446 Slow queries: 0 Opens: 156 Flush tables: 1 Open tables: 149 Queries per second avg: 1.875
--------------
+---------------+--------------------+
| Variable_name | Value |
+---------------+--------------------+
| Ssl_cipher | DHE-RSA-AES256-SHA |
+---------------+--------------------+
1 row
in
set
(0.01 sec)
+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Ssl_cipher_list | DHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA:AES128-RMD:DES-CBC3-RMD:DHE-RSA-AES256-RMD:DHE-RSA-AES128-RMD:DHE-RSA-DES-CBC3-RMD:AES256-SHA:RC4-SHA:RC4-MD5:DES-CBC3-SHA:DES-CBC-SHA:EDH-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC-SHA:AES128-SHA:AES256-RMD |
+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row
in
set
(0.00 sec)
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed
in
8.0
Sat Apr 22 19:09:20 CST 2017 WARN: Establishing SSL connection without server
's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn'
t
set
. For compliance with existing applications not using SSL the verifyServerCertificate property is
set
to
'false'
. You need either to explicitly disable SSL by setting useSSL=
false
, or
set
useSSL=
true
and provide truststore
for
server certificate verification.
MySql.Data.MySqlClient.MySqlException：“主机本地主机不支持SSL连接”
MySql.Data.MySqlClient.MySqlException：“主机本地主机不支持SSL连接”
.NET HttpWebRequest（请求被中止: 未能创建 SSL/TLS 安全通道）和（基础连接已经关闭: 发送时发生错误）问题查找解决
.NET HttpWebRequest（请求被中止: 未能创建 SSL/TLS 安全通道）和（基础连接已经关闭: 发送时发生错误）问题查找解决
问题是这样的：小程序的wx对应ws协议，wxs对应wss协议，本篇文章介绍了：1、如何解决真机调试mqtt报错连接不上的问题
2、调试通过后，去除勾选不校验合法域名，连接8084端口失败的解决办法（本文内容）
经过3天的不断尝试，用尽了网上很多办法，对MQT
SSL连接出错的原因都有哪些？
SSL连接出错的原因都有哪些？ SSL连接是SSL概念中一个极其重要的存在，它指的是利用数据加密技术 ，来确保数据在网络传输中不被截取。由此可以看到，若是SSL连接过程出现了错误，就不能确保数据传输的安全性了，那么可能引起SSL连接出错的原因都有哪一些呢？ 一、SSL证书不是由受信任的证书颁发机构颁发，即SSL证书不在所用浏览器厂商受信任的列表之中。
SSL连接出错的原因都有哪些？
SSL连接是SSL概念中一个极其重要的存在，它指的是利用数据加密技术 ，来确保数据在网络传输中不被截取。由此可以看到，若是SSL连接过程出现了错误，就不能确保数据传输的安全性了，那么可能引起SSL连接出错的原因都有哪一些呢？ 一、SSL证书不是由受信任的证书颁发机构颁发，即SSL证书不在所用浏览器厂商受信任的列表之中。
