mysql.user
display:
display:
Query OK, 0 rows affected (0.00 sec)Empty set (0.00 sec)Query OK, 0 rows affected (0.00 sec)+-----------+-------+------+| host | user | db |+-----------+-------+------+| localhost | monty | test |+-----------+-------+------+1 row in set (0.00 sec)
mysql.host\
#未测试
mysql.tables_priv
Empty set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
+-----------+------+------------+-------+
| host | db | table_name | user |
+-----------+------+------------+-------+
| localhost | test | student | monty |
+-----------+------+------------+-------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql.columns_priv
Empty set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
+-----------+------+-------+------------+-------------+-------------+
| host | db | user | table_name | column_name | column_priv |
+-----------+------+-------+------------+-------------+-------------+
| localhost | test | monty | student | sno | Select |
+-----------+------+-------+------------+-------------+-------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)