360SDN.COM

首页/MySQL/列表

安装完绿色版MySQL修改密码:ERROR 1820 (HY000): You must reset your password usin

来源:  2018-07-17 15:21:05    评论:0点击:

安装完绿色版MySQL修改密码:ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this statement.


mysql> update mysql.user set password=PASSWORD('123456') where User='root';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo
re executing this statement.

 

参考:http://dev.mysql.com/doc/refman/5.6/en/alter-user.html

 

直接执行:set password=password('密码');

搞定!!!

为您推荐

友情链接 |九搜汽车网 |手机ok生活信息网|ok生活信息网|ok微生活
 Powered by www.360SDN.COM   京ICP备11022651号-4 © 2012-2016 版权