GRANT ALL PRIVILEGES ON test.* TO username@'192.168.1.%' IDENTIFIED BY 'goodsecret'; FLUSH PRIVILEGES;
