mysql 5.6 bug
https://dev.mysql.com/doc/refman/5.6/en/account-management-sql.html
USE mysql;
SELECT Host,User FROM user;
【BUG】
CREATE USER 'xx'@'%' IDENTIFIED BY 'yy';GRANT ALL PRIVILEGES ON *.* TO 'xx'@'%' WITH GRANT OPTION;
#ERROR 1045 (28000): Access denied for user 'xx'@'localhost' (using password: YES)
CREATE USER 'xx'@'localhost' IDENTIFIED BY 'yy';GRANT ALL PRIVILEGES ON *.* TO 'xx'@'localhost' WITH GRANT OPTION;
DROP USER 'xx'@'%';
DROP USER 'll'@'%';
【5.6 无效,在没重启服务的情况下；未测5.7、重启】
UPDATE user SET Password='newyy' WHERE User='xx';
#ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
#SET PASSWORD FOR 'xx'@'localhost' = '123';
【有效】
SET PASSWORD FOR 'xx'@'localhost' = PASSWORD('123');
mysql> SELECT Host,User FROM user;
+-------------------+------+
| Host | User |
+-------------------+------+
| % | xx |
| 127.0.0.1 | root |
| ::1 | root |
| bigdata-server-02 | |
| bigdata-server-02 | root |
| localhost | |
| localhost | root |
| localhost | xx |
+-------------------+------+
8 rows in set (0.00 sec)
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root123');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('root123');
SET PASSWORD FOR 'root'@'bigdata-server-02' = PASSWORD('root123');
SET PASSWORD FOR 'root'@'::1' = PASSWORD('root123');
最新文章
- C#实现php的hash_hmac函数
- No enclosing instance of type E is accessible. Must qualify the allocation with an enclosing
- Java日期与时间的处理/Date,String,Calendar转换
- CentOS7 安装Redis 3.2.3
- memcached在windows安装
- C#中HashTable的用法示例1
- mybatis0207 resultType、resultMap、延迟加载使用场景总结
- [Android] 输入系统（二）
- return和break的区别
- SSAS系列——【08】多维数据（程序展现Cube）
- xhEditor入门基础
- Centos7 创建本地 docker 仓库极其遇到的问题
- ASP.NET在MVC控制器中获取Form表单值的方法
- SQL Server DDL
- System.net.mail.smtpException;服务器提交了协议冲突 服务器响应为：
- Java抽象类(Abstract Class)与接口(Interface)区别
- SpringSecurity-RememberMeAuthenticationFilter的作用
- lintcode 单词接龙II
- UVa 1151 买还是建
- Leetcode题库——12.整数转罗马数字