配置Inforsuite连接mysql数据库，始终报 Communications link failure解决办法

第一步：导入mysql驱动到inforsuite域目录下

(2) 配置数据源

（3）测试数据源报如下错误：

2019-11-15 03:19:07 [SEVERE]RAR5110 : Error creating managed Connection with user and password : {0} com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)         at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)         at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)         at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)         at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)         at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)         at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)         at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)         at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)         at java.sql.DriverManager.getConnection(DriverManager.java:582)         at java.sql.DriverManager.getConnection(DriverManager.java:154)         at com.sun.gjc.spi.DMManagedConnectionFactory.createManagedConnection(DMManagedConnectionFactory.java:165)         at com.cvicse.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl. java:697)         at com.cvicse.enterprise.connectors.service.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.jav a:426)         at com.cvicse.enterprise.connectors.ConnectorRuntime.pingConnectionPool(ConnectorRuntime.java:1086)         at com.cvicse.loong.connectors.admin.cli.PingConnectionPool.execute(PingConnectionPool.java:130)         at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:348)         at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363)         at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1066)         at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95)         at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291)         at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1259)         at com.cvicse.loong.admin.rest.ResourceUtil.runCommand(ResourceUtil.java:214)         at com.cvicse.loong.admin.rest.resources.TemplateExecCommand.executeCommand(TemplateExecCommand.java:127)         at com.cvicse.loong.admin.rest.resources.TemplateCommandGetResource.processGet(TemplateCommandGetResource.java:78)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597)         at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)         at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDisp atchProvider.java:205)         at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)         at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)         at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)         at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)         at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)         at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)         at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)         at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)         at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)         at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483)         at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414)         at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363)         at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353)         at com.sun.jersey.server.impl.container.grizzly.GrizzlyContainer._service(GrizzlyContainer.java:182)         at com.sun.jersey.server.impl.container.grizzly.GrizzlyContainer.service(GrizzlyContainer.java:147)         at com.cvicse.loong.admin.rest.adapter.RestAdapter.service(RestAdapter.java:148)         at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)         at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117)         at com.sun.enterprise.v3.services.impl.ContainerMapper$Hk2DispatcherCallable.call(ContainerMapper.java:354)         at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)         at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)         at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)         at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)         at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)         at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)         at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)         at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)         at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)         at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)         at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)         at com.sun.grizzly.ContextTask.run(ContextTask.java:71)         at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)         at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)         at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

（4） 解决办法：

 1） 测试时通信链路失败，出现该问题说明url、用户名或者密码错误，所以我使用myeclipse编写脚本测试如下：

可以很明显的看到： "Host 'DESKTOP-1Q0KDIQ' is not allowed to connect to this MySQL server"报错，说明mysql不支持该远程host连接引起的报错，解决办法如下：

进入数据库 ，将root的用户的host 属性  设置为%（代表匹配所有host）

在myeclipse中重新运行，成功:

再次测试数据源，测试成功：