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 |
| | gnchen |
and is the address of host test.
2、then I grant different privileges to the two different account:
grant select on X.Y to gnchen@ and grant nothing to the other.
3、then I make a connection from 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

Written By
ip address to host name
February 14, 2017 09:07AM
February 20, 2017 08:10AM
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.