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

创建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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26585184/viewspace-1662744/