CODE EXAMPLE FOR SQL

mysql set user password for a range of ips

GRANT ALL PRIVILEGES ON database.* TO 'user'@'81.10.20.1/255.255.255.240';