mysql5.7 修改密码 遇到的问题及解决方法

错误1：

Unknown column 'Password' in 'field list'

错误原因：mysql数据库下已经没有password这个字段了，password字段改成了authentication_string。

mysql> update mysql.user set authentication_string=PASSWORD('password') where User='root';
Query OK, 1 row affected, 1 warning (0.15 sec)
Rows matched: 1 Changed: 1 Warnings: 1

错误2：

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

原因：密码太简单，密码由大写、小写、字符、数字组成

错误3：

ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

原因：mysql5.7版本开始创建用户需要create user

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'

错误4：

1130-host ... is not allowed to connect to this MySql server 

原因：没有开启远程登录

mysql>use mysql;

mysql>update user set host = '%' where user = 'root';

mysql>select host, user from user;