MySQL执行更改密码类型命令报错ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;1、问题是mysql中user表中显示host是%号，所以这里的localhost 更换成%即可select Host,user from user；
·
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
1、问题是mysql中user表中显示host是%号，所以这里的localhost 更换成%即可
select Host,user from user；
为开发者提供学习成长、分享交流、生态实践、资源工具等服务，帮助开发者快速成长。
更多推荐
4
0- 0
已为社区贡献5条内容
所有评论(0)