MySql授权远程登录

总是记不住，在此记一下：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'username'@’192.168.1.%’ IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;