Home >Database >Mysql Tutorial > MySQL5.6创建用户密码不再明文显示在binlog二进制日志文件里
MySQL5.6创建用户密码不再明文显示在binlog二进制日志文件里
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 17:36:381419browse
MySQL5.5里：MySQL5.6里：已经加密。但如果updatemysql.usersetpassword=password(654321)whereUser=hcy;还会是明文，如图：测试环境binlog_format=MIXED改为ROW
MySQL5.5里：
MySQL5.6里：
已经加密。
但如果
update mysql.user set password=password('654321') where User='hcy';还会是明文，，如图：
测试环境
binlog_format = MIXED改为ROW模式：
加密。
本文出自 “贺春旸的技术专栏” 博客，请务必保留此出处
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： mysql隐形转换造成索引失效的事故总结Next article： 全文索引对索引选择的干扰