mysql远程访问受限

‘127.0.0.1’ is not allowed to connect to this MySQL serverConnection closed by foreign host

远程访问权限
    安装了mysql，然后用telnet　ip　3306,端口后报BHost ‘127.0.0.1’ is not allowed to connect to this MySQL serverConnection closed by foreign host,虽然自己以前也碰到过，后来解决了,但是觉得还是值得贴出来,估计会有很多人同样碰到过,贴个解决办法:
    mysql>UPDATE mysql.user SET Host='%' WHERE Host='localhost';
    mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" ;
    mysql>FLUSH PRIVILEGES;