Mysql5.7 有关于密码的错误（ERROR 1054 (42S22): ，ERROR 1820 (HY000):）

ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’

password 已经不适用了 将其改为为authentication_string

故更改密码的语句为
update mysql.user set authentication_string=password(‘root’) where user=‘root’

密码形式必须包含大写，小写，数字，特殊符号。否则会有密码保护级别过低的错误

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

按照提示要求修改密码即可。
ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘Mbw123456.’;