过程如下:
mysql> revoke all on *.* from 'levi'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for `levi`;
+-----------------------------------------------------------------------------------------------------------------------+
| Grants for levi@% |
+-----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'levi'@'%' IDENTIFIED BY PASSWORD '抱歉呀,这个我隐藏啦= =~~~~~~~~~~~~~~~~~~~~' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `wordpress`.* TO 'levi'@'%' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------------+
那结果就是,登录levi这个用户之后,可以查看所有的数据库,只能操作wordpress这个数据库
我希望的是,登录levi这个用户之后,只能查看、操作wordpress这个数据库