解决mysql安装不能被远程访问 message from server: “Host ‘*‘ is not allowed to connect to this MySQL server“

错误信息如下：null, message from server: "Host '172.16.214.94' is not allowed to connect to this MySQL server"

解决办法：查询用户并设置用户权限，操作步骤如下：

1.mysql -u root -p;

2.use mysql;

3.select user,host from user;

4.update user set host='%' where user = 'root';

5.select user,host from user;

6.flush privileges;