--针对某个库做授权 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 例如：grant all on bank_reserve.* to bank@'%' identified by "zhongrui123@#" with grant option;grant all on *.* to root@'%' identified by "123456" with grant option;
--收回某个库权限revoke all on bool.* from myuser@'192.168.1.%';
--针对表做权限grant insert,update,select on gy3.goods to lisi@'192.168.1.%';
-- 刷新权限
flush privileges;
转载于:https://www.cnblogs.com/Luke-Me/p/8963459.html
