1、创建用户、赋予权限
CREATE USER ‘scadm‘ IDENTIFIED BY ‘scadm‘; GRANT ALL ON `db1`.* TO ‘scadm‘; GRANT ALL ON `db2`.* TO ‘scadm‘; GRANT ALL ON `db3`.* TO ‘scadm‘;revoke all on db3.* from scadm; //撤销权限
【笔记】Mysql常用sql
原文：https://www.cnblogs.com/itplay/p/10983244.html
