MySQL Forums
Forum List  »  Security

ip address to host name
Posted by: aaron chan
Date: February 14, 2017 09:07AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
ip address to host name
2184
February 14, 2017 09:07AM
927
February 20, 2017 08:10AM
607
February 20, 2017 07:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.