MySQL Forums
Forum List  »  Newbie

multiple host not work
Posted by: Ah Eng
Date: November 16, 2017 08:38AM

I create user with
Grant all on *.* to user1@123.123.123.123/255.255.255.0 identified by "password";

but when i access it within the subnet it not work. but i create with direct ip it work.
user1@123.123.123.122
user1@123.123.123.121

any place need to set to enable user1@123.123.123123/255.255.255.0 to work?

under MYSQL 5.7 and 5.6
win2012r2 and win10

Options: ReplyQuote


Subject
Written By
Posted
multiple host not work
November 16, 2017 08:38AM
November 16, 2017 08:45AM
November 16, 2017 02:37PM
November 16, 2017 09:23PM
November 16, 2017 09:33PM
November 16, 2017 10:16PM
November 16, 2017 10:41PM


Sorry, only registered users may post in this forum.

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.