MySql五个授权表的功能

mysql.user

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

display:

+-----------+------+-------------------------------------------+| host      | user | password                                  |+-----------+------+-------------------------------------------+| localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |+-----------+------+-------------------------------------------+1 row in set (0.00 sec)Query OK, 0 rows affected (0.01 sec)+-----------+-------+-------------------------------------------+| host      | user  | password                                  |+-----------+-------+-------------------------------------------+| localhost | root  | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 || localhost | monty | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |+-----------+-------+-------------------------------------------+2 rows in set (0.00 sec)

mysql.db

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)

	
				
	
					   
MySql五个授权表的功能
	  	   
MySQL授权系统的五个表
	  	   
mysql对新用户的数据库表授权
	  	   
mysql的授权问题
	  	   
mysql的授权问题
	  	   
mysql授权表
	  	   
mysql  授权表tables_priv
	  	   
MYSQL授权表
	  	   
mysql授权表
	  	   
mysql 的触发器和授权
	  	   
MYSQL的授权远程登录
	  	   
分析MySQL的授权许可
	  	   
MySQL数据库的授权原则
	  	   
linux下的mysql授权
	  	   
MySQL的用户和授权
	  	   
MySQL的初始化,密码,授权
	  	   
mysql 只给更新表的某个字段的授权
	  	   
优化MySQL插入方法的五个妙招
	     		  
	  	   
线程和进程间的相似处与区别
	  	   
深入C++的new和traits
	  	   
java多线程应用——生产者消费者
	  	   
表达式求值（c++实现）
	  	   
python time模块详解
	  	   
MySql五个授权表的功能
	  	   
百度Android开发面试题
	  	   
单片机  定时器计数器的相关
	  	   
计算机视觉领域研究资源及期刊、会议介绍 ——看看大牛都在做什么
	  	   
Oracle Flashback Database and Restore Points 说明
	  	   
cocos2d-x 如何使用Visual Studio 2010和xcode 4混合编写手机游戏
	  	   
机器视觉领域的牛人们的博客
	  	   
Visulal C++是什么？——兼谈其他
	  	   
swt中的SashForm