ITPub博客

首页 > 数据库 > MySQL > mysql中多个相同用户名登入验证匹配优先级

mysql中多个相同用户名登入验证匹配优先级

原创 MySQL 作者:leegstar 时间:2015-05-19 17:48:12 0 删除 编辑

创建lgx用户,设置密码,不指定host,host值为%

(root@localhost) [(none)]> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | lvs       | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | 127.0.0.1 | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | ::1       | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| lgx  | %         | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
+------+-----------+----------------------------------------------------------------------------+

使用密码登入成功
[mysql@lvs ~]$ mysql -ulgx -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.6.21-log LGX FOR MYSQLTEST


Copyright (c) 2000, 2014, 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@lvs ~]$ mysql -ulgx
ERROR 1045 (28000): Access denied for user 'lgx'@'localhost' (using password: NO)


-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

在创建lgx用户,并指定host=localhost,无密码

(root@localhost) [(none)]> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | lvs       | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | 127.0.0.1 | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| root | ::1       | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| lgx  | %         | *7F00590C81FE53D8C01B98A186675481BD8ED06B |
| lgx  | localhost |                                           |
+------+-----------+-------------------------------------------+
6 rows in set (0.01 sec)

使用密码登入lgx,登录失败
[mysql@lvs ~]$ mysql -ulgx -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'lgx'@'localhost' (using password: YES)


----------------------------
无密码登录入成功

[mysql@lvs ~]$ mysql -ulgx
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.6.21-log LGX FOR MYSQLTEST


Copyright (c) 2000, 2014, 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中多个相同用户名登入验证时,相同用户名排序时,会host值优先排序,通配符‘%’类的排序优先级靠后

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26585184/viewspace-1662744/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-12-28

  • 博文量
    31
  • 访问量
    129266