MySQL 5.7.18 加密连接mysql_ssl_rsa_setup

by Posted on

MySQL 5.7.18 下载地址: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

安装步骤见 http://www.linuxidc.com/Linux/2017-10/148130.htm

#修改已存在用户
mysql> ALTER USER 'dba'@'%' REQUIRE SSL;
				
#新建必须使用SSL用户
mysql> grant select on *.* to 'dba'@'%' identified by 'xxx' REQUIRE SSL;
				

[root@001 mysql] mysqll -h 10.126.xxx.xxx -u dba -p --ssl


Enter password: 



ERROR 1045 (28000): Access denied for user 'dba'@'10.126.xxx.xxx' (using password: YES)























































：http://www.linuxidc.com/Linux/2017-10/148131.htm



							


			

		

	




							


	

			


	

		

            Published by cloud