1、my mysqld server has two entries in mysql.user table for user "gnchen":
+-------------+-----------+
| host | user |
+-------------+-----------+
| test | gnchen |
| 192.168.8.6 | gnchen |
and 192.168.8.6 is the address of host test.
2、then I grant different privileges to the two different account:
grant select on X.Y to
gnchen@192.168.8.6 and grant nothing to the other.
3、then I make a connection from 192.168.8.6 client.
the output below shows that this connection is from gnchen@test.
Connection id: 40
Current database:
Current user: gnchen@test
HOWEVER,under this circumstance I find myself can issue the select statement to X.Y table!!!
Is this a correct phenomenon?