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