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’ ;