access denied for [email protected]

建立的新用户，xxx@’%’，授权后，本地只能通过公网链接，不能通过localhost或者127.0.0.1链接，解决方案：赋予对应主机权限。

如：

       grantall privileges on *.* to [email protected] identified by ‘password’ ;

       grantall privileges on mydb.* to [email protected] identified by ‘password’ ;

       grantall privileges on mydb.* to [email protected] identified by ‘password’ ;