mysql中多个相同用户名登入验证匹配优先级_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2212 | 回复: 0

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

Irvinna

注册用户

等级：新兵
经验：51
发帖：46
精华：0
注册：2011-8-19
状态：离线
发送短消息息给Irvinna

加好友发送短消息息给Irvinna

发消息

发表于：

2015-8-13 10:44:54 | [全部帖] [楼主帖]

楼主

创建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，无密码

使用密码登入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值优先排序，通配符‘%’类的排序优先级靠后

--转自