mysql8权限控制

# 新建用户
CREATE USER 'test'@'xxx.xx.xx.%' IDENTIFIED BY '123';
grant all privileges on *.* to 'test'@'xxx.xx.xx.%' IDENTIFIED BY '123' with grant option;
flush privileges;  

# 新建用户
CREATE USER 'test'@'xxx.xx.xx.%' IDENTIFIED BY '123';
grant Select,Insert on db.test_table to 'test'@'xxx.xx.xx.%' IDENTIFIED BY '123' with grant option;
flush privileges;  

# 修改密码
alter user 'root'@'132.151.26.%' identified by 'Bonc*J??M6lj';