mysql远程连接不被允许连接

    错误： null, message from server: "Host '146.56.230.48' is not allowed to connect to this MySQL server"

1.云主机防火墙已放行
2.数据库放心HOST:
3.执行SQL： 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'146.56.230.48' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
 除了执行SQL还有一个办法： 使用宝塔 设置数据库权限。