mysql 设置允许网段连接 mysql网段授权

# 查看用户拥有的权限
select * from mysql.user where user='syj'\G 
 
# 授权的必要条件：需要登录root用户进行授权 # 
# 授权syj所有的权限，但是只能在本地登录数据库操作 
grant all privileges on *.* to 'syj'@'localhost' identified by 'passwd';
flush privileges;
 
# 授权syj所有的权限，允许在192.168.1.1网段内登录操作
grant select on *.* to 'syj'@'192.168.1.%' identified by 'passwd'; 
flush privileges;
 
# 授权syj只有select所有库的权限，但是只能在192.168.1.1网段内登录操作
grant select on *.* to 'syj'@'192.168.1.%' identified by 'passwd';
flush privileges; 
 
#  授权用户报错
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
pastingERROR 1819 (HY000): Your password does not satisfy the current policy requirements
# 解决方法
set global validate_password_policy=LOW;