create User If not Exists 'shoppe'@'127.0.0.%'
identified by '123456';
alter user 'shoppe'@'127.0.0.%' password expire;
Show Databases;
alter user 'shoppe'@'127.0.0.%' identified by '2c5-98h';
grant select on sh_goods to 'shoppe'@'127.0.0.%';
drop table shoppe.sh_goods;
Revoke Select On shoppe.sh_goods
From 'shoppe'@'127.0.0.%';
Drop User If Exists 'shoppe'@'localhost';
mysql创建用户及权限管理
最新推荐文章于 2022-03-22 23:01:35 发布