idea 数据库连接错误 Host '192.168.8.239' is not allowed to connect to this MySQL server"

用idea 打开别人的项目，按照配置都已经完成，运行一直报这个错误  Host '192.168.8.239' is not allowed to connect to this MySQL server" 根据信息提示是数据不允许远程连接，

1首先关闭防火墙 系统偏好设置->安全与隐私中设置

2 数据配置检查

resources/application.yml

#数据库连接配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/zblog?characterEncoding=utf8
    username: root
    password: kangxg198811
    driver-class-name: com.mysql.jdbc.Driver

3. 命令行授权：

 mysql -u root -p
 use zblog;

grant all privileges on zblog.* to root@'%' identified by 'kangxg198811';

flush privileges ; 

参考文章 http://blog.youkuaiyun.com/timo1160139211/article/details/72831771