mysql 授权给多个表_MySql五个授权表的功能

drop user monty@localhost;

select host,db,user from mysql.db;

grant all privileges on test.* to monty@localhost identified

by '123456' with grant option;

select host,user,db from 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

select * from tables_priv;

grant all privileges on test.student to monty@localhost

identified by '123456' with grant option;

select host,db,table_name,user from tables_priv;

drop user monty@localhost;

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

select * from columns_priv;

grant select(sno) on test.student to monty@localhost

identified by '123456' with grant option;

select host,db,user,table_name,column_name,column_priv from

columns_priv;

drop user monty@localhost;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)