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;