MySQL Forums
Forum List  »  Security

user allowed from % (host) but able to login locally as well
Posted by: Vaibhav Upadhyay
Date: April 25, 2017 12:10AM

Version : 5.6.35-log MySQL Community

Problem : User is not allowed to login locally but user is able to login locally (from server) to Database.

===========user privileges=========
grant select on xx.* to user@'%' identified by password;

Anyway to restrict the user to connect to database locally, apart from allowing from specific ip (by using % as a host)?

Options: ReplyQuote


Subject
Views
Written By
Posted
user allowed from % (host) but able to login locally as well
928
April 25, 2017 12:10AM


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.