1、ERROR 1054 (42S22): Unknown column 'password' in 'field list'
解决方式:
update mysql.user set authentication_string=password('123456') where user='root'; #修改密码成功
2、ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
解决方式:select @@validate_password_length;
查询密码长度,默认为8,需要重新设置
set global validate_password_policy=0;
set global validate_password_length=1;
set global validate_password_mixed_case_count=2;
此时就可以设置123456的密码了
3、远程访问
查询 select host,user,authentication_string from user;
授权 grant all privileges on *.* to root@'%' identified by "password";
flush privileges;
select host,user,authentication_string from user;