遠端連接配接mysql報錯Host * is not allowed to connect to this MySQL server 解決方法

mysql -u root -p （mysql登入密碼）

use mysql

update user set host =’%'where user =‘root’ and host =‘localhost’;

flush privileges;