web用ip访问mysql,提示:Host is not allowed to connect to this MySQL server
解决方法
use mysql;
select host,user from user;
#set sql_safe_updates=off;
update user set host = '%' where user = 'root';
commit;
FLUSH PRIVILEGES;
use mysql;
select host,user from user;
#set sql_safe_updates=off;
update user set host = '%' where user = 'root';
commit;
FLUSH PRIVILEGES;