"Host 'xxx' is not allowed to connect to this MySQL server")。navicat

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null,  message from server: "Host '172.22.1.243' is not allowed to connect to this MySQL server")

意思是不能连接远程数据库。

解决方法。以navicat为例

首先打开数据库的mysql表。打开user表

然后修改host为%。保存

最后必须重启mysql。切记