mysql创建用户 并授权 增删改查的权限
2022-10-19 本文已影响0人
flyjar
create user 'natergy_shop'@'%' identified by 'natergy_shop@!#@12';
grant INSERT on natergy_shop.* to 'natergy_shop'@'%';
grant DELETE on natergy_shop.* to 'natergy_shop'@'%';
grant UPDATE on natergy_shop.* to 'natergy_shop'@'%';
grant SELECT on natergy_shop.* to 'natergy_shop'@'%';
flush privileges;
