创建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值优先排序,通配符‘%’类的排序优先级靠后
--转自