grant all on . to admin2@"%" identified by "123456" with grant option; Query OK, 0 rows affected, 1 warning (0.00 sec) all 匹配所有权限 . 匹配所有库和表 ” %“ 匹配所有主机 授权用户admin3 允许对192.168.4.0/24网段访问 mysql> grant all on . to [email?protected]/24‘ identified by "12" />

mysql grant proxy on_mysql grant配置授权

发布于:2021-12-05 19:56:30

grant 权限l列表 on 库名.表名 [email?protected] identified by " 密码" [ with grant opion ];


mysql> grant all on . to admin2@"%" identified by "123456" with grant option;


Query OK, 0 rows affected, 1 warning (0.00 sec)


all 匹配所有权限


. 匹配所有库和表


” %“ 匹配所有主机


授权用户admin3 允许对192.168.4.0/24网段访问


mysql> grant all on . to [email?protected]/24‘ identified by "123456" with grant option;


Query OK, 0 rows affected, 1 warning (0.00 sec)


对用户admin4在daydb4.user1仅有查询权限 登录密码为123456


mysql> grant select on daydb4.user1 to admin4@"localhost" identified by "123456" with grant option;


Query OK, 0 rows affected, 1 warning (0.00 sec)


授权admin5 允许i本机访问,对daydb4任何表有查询 更改 插入 删除 权限 密码123456


mysql> grant select,update,delete,insert on daydb4.* to admin4@"localhost" identified by "123456" with grant option;


Query OK, 0 rows affected, 1 warning (0.01 sec)


用户查看自己的授权


mysql> show grants;


+---------------------------------------------------------------------+


| Grants for [email?protected] |


+---------------------------------------------------------------------+


| GRANT ALL PRIVILEGES ON . TO [email?protected] WITH GRANT OPTION |


| GRANT PROXY ON [email?protected] TO [email?protected] WITH GRANT OPTION |


+---------------------------------------------------------------------+


2 rows in set (0.00 sec)


root 查看其他人用户的授权


show grant for [email?protected];


mysql> show grants for admin4@"localhost" g;


+----------------------------------------------------------------------------------------------+


| Grants for [email?protected] |


+----------------------------------------------------------------------------------------------+


| GRANT USAGE ON . TO [email?protected] |


| GRANT SELECT, INSERT, UPDATE, DELETE ON daydb4.* TO [email?protected] WITH GRANT OPTION |


| GRANT SELECT ON daydb4.user1 TO [email?protected] WITH GRANT OPTION |


+----------------------------------------------------------------------------------------------+


3 rows in set (0.00 sec)


用户链接后修改密码


set password=password("新密码");


[[email?protected] ~]# mysql -uadmin4 -p654321


[[email?protected] ~]# mysql -uadmin4 -p654321


mysql: [Warning] Using a password on the command line interface can be insecure.


Welcome to the MySQL monitor. Commands end with ; or g.


Your MySQL connection id is 41


Server version: 5.7.17 MySQL Community Server (GPL)


Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its


affiliates. Other names may be trademarks of their respective


owners.


Type ‘help;‘ or ‘h‘ for help. Type ‘c‘ to clear the current input statement.


mysql>


mysql> set password=password("123456");


Query OK, 0 rows affected, 1 warning (0.00 sec)


原文:http://blog.51cto.com/14066708/2319629

相关推荐

最新更新

猜你喜欢