mysql连接显示“message from server :“Host ‘XXXX‘ is not allowed to connect to this MySQL server“”

问题原因：mysql服务器出于安全考虑，默认只允许本地登陆数据库服务器

问题解决：更改mysql数据库里的“user”表里的“host”项，从“localhost”改成“%”，然后重启mysql就可以进行访问

use mysql;

update user set host = ‘%’ where user = “root”;

flush privileges;

select host,user from user;