错误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;