为指定IP授权
GRANT ALL PRIVILEGES ON *.* TO ‘userName‘@‘ip‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
泛授权
GRANT ALL PRIVILEGES ON *.* TO ‘userName‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
mysql授权
原文：http://www.cnblogs.com/tomcatx/p/3987359.html
