--针对某个库做授权
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;