mysql> show grants for 'hxldev'@'%';
+-------------------------------------------------------------------------------------------------------+
| Grants for hxldev@% |
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'hxldev'@'%' IDENTIFIED BY PASSWORD '*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA' |
| GRANT USAGE ON `db_test02`.`db_test.*` TO 'hxldev'@'%' WITH GRANT OPTION
请问下usage权限不能回收的吗，我执行了如下，发现不能回收.
revoke USAGE ON `db_test02`.`db_test.*` from 'hxldev'@'%'
作者: seesea2517 时间: 2018-07-12 16:22
可以，你 drop user 就好了。如果一个用户没有 usage 权限，那可真是生不如死啊。