阿里云ecs轻量服务器配置mysql

错误一：Host ‘XXX’ is not allowed to connect to this MySQL server解决方案

1、mysql -uroot -p   //登录数据库

2、show  databases; //查看数据库

3、use mysql    //使用mysql库

4.select host from user where user='root';

5、update user set host = ‘%’ where user = ‘root’;//更新  修改

6、再确认 ：select host from user where user='root';

7、FLUSH   PRIVILEGES;//刷新权限