搭建mysql数据库问题汇总

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;