mysql 权限安全管理系统_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加密