安装mysql遇到的问题

1、修改密码过于简单，修改密码规则

mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password.length=1;
Query OK, 0 rows affected (0.00 sec)

　　

2、远程登录问题需要添加用户

 查看所有账号

select host,user from user;

　　

 

 

 添加用户

create user 'cloudy'@'%' identified by '密码';

　　

查看用户权限

show grants for 'cloudy'@'%';

　　

设置用户权限（这里赋予了所有权限）

grant all privileges on *.* to "cloudy"; 

　　

3、远程连接出现 “Authentication plugin 'caching_sha2_password' cannot be loaded”

 

   ALTER USER 'cloudy'@'%' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;   #修改加密规则 
   ALTER USER 'cloudy'@'%' IDENTIFIED WITH mysql_native_password BY '密码';   #更新用户密码 
   FLUSH PRIVILEGES;