mysql 表授权_MySQL五个授权表的功能

mysql.user select host,user,password from mysql.user; grant all privileges on *.* to monty@localhost identified by

mysql.user

display:

mysql.db

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

display:

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

display：

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)

，

本文原创发布php中文网，转载请注明出处，感谢您的尊重！