56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> SHOW GRANTS for M1234;
+--------------------------------------------------------
| Grants for M1234@%
+--------------------------------------------------------
| GRANT USAGE ON *.* TO 'M1234'@'%' IDENTIFIED BY PASSWOR
| GRANT SELECT ON `xx`.* TO 'M1234'@'%'
+--------------------------------------------------------
-----------------------+
2 rows in set (0.00 sec)
mysql> drop database xx;
Query OK, 0 rows affected (0.28 sec)
mysql> SHOW GRANTS for M1234;
+--------------------------------------------
| Grants for M1234@%
+--------------------------------------------
| GRANT USAGE ON *.* TO 'M1234'@'%' IDENTIFIE
| GRANT SELECT ON `xx`.* TO 'M1234'@'%'
+--------------------------------------------
2 rows in set (0.00 sec)
mysql>