MySQL5.7数据库密码修改与报错

“错误代码： 1054 Unknown column 'Password' in 'field list'”

1. 修改密码：UPDATE USER SET PASSWORD = PASSWORD('新密码') WHERE USER = '用户名';  

2. 原因：MySQL 5.7后，PASSWORD字段改为了authentication_string;

3. 解决：
    * UPDATE mysql.`user` SET authentication_string = PASSWORD('新密码') WHERE USER = '用户名';
    * FLUSH PRIVILEGES;

• 参考自：https://www.cnblogs.com/wangbaobao/p/7087032.html

转载于:https://www.cnblogs.com/summerbegins/p/11283152.html