MYSQL 安全性之授权管理表

一.查看当前数据库下存在的表

mysql>SHOW TABLES;

Tables_in_mysql

表1

表2

~~

二.介绍与用户权限相关的表

1.mysql.user表（包括用户名称、主机名、密码、操作权限等内容）

（1）用户字段

查看代码：mysql>SELECT Host,User,Passward FROM mysql.user WHERE User='root'\G

输出代码：·······································1.row··········································

　　　　　　Host:localhost

　　　　　　User:root

　　　  Passward:*81F~

　　　　　````````````````````````````````````````2.row`````````````````````````````````````````

　　　　　Host:127.0.0.1

　　　　　User:root

　　   Passward:*81~

　　　　　```````````````````````````````````````3.row```````````````````````````````````````````

　　　　　Host:：：1

　　　　　User:root

　　  Passward:*81F~

　　3 rows in set (0.00sec)

　　用户登陆时会先判断这3个字段的值，如果这3个字段同时匹配，MYSQL数据可系统才会允许登陆。而且创建用户时，也是设置这3个字段的值，修改用户密码时，实际上就是在修改user表中的Passward字段的值。

2.权限字段

（1）查询、修改、添加权限

代码：mysql> SELECT Select_priv,Insert_priv,Update_priv,User,Host FROM user

　　　　->WHERE User='root' AND Host ='localhost'

3.安全字段

代码：mysql>SHOW VARIABLES LIKE 'have_openssl'

输出：have_openssl     '这表示不支持ssl加密