Link to home
Create AccountLog in
Avatar of sitg
sitgFlag for Iceland

asked on

MySQL 5.1 User

hi,

I have assigned user @'%' permission on the database, but now i want to restrict user access from limited IPs.
syntax used:
Grant all privileges on mytestdb.*  to myuser@'%' identified by 'mytest123';
how i can revoke '%' and define the specified IPs

Please advice.



Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

as in MySQL, you cannot "DENY", you have to revoke all permissions to the % user, and create only those users/ip that are allowed.
ASKER CERTIFIED SOLUTION
Avatar of Steve Tempest
Steve Tempest
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account