首先登录MySQL。
格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');
https://www.cnblogs.com/qianzf/p/7089197.html
结果发现报错:error 1064
原因是MySQL5.7.6版本以后,password属性已经取消(使用SELECT Password (‘123’)报错),
并且修改用户密码的语句已经改变
mysql>alter user root identified by '123456';
https://blog.youkuaiyun.com/chenmoshashou2/article/details/80464911
上面的语句执行失败,修改:
mysql>alter user root@localhost identified by '123456';
成功!!!