MySQL8.0+sonarqube-6.7.1连接报错求大神帮忙看看

FHJXS 2019-03-27 06:57:43

2019.03.27 18:44:23 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2019.03.27 18:44:24 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2019.03.27 18:44:27 INFO web[][o.e.p.PluginsService] no modules loaded
2019.03.27 18:44:27 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.index.reindex.ReindexPlugin]
2019.03.27 18:44:27 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2019.03.27 18:44:27 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2019.03.27 18:44:27 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2019.03.27 18:44:32 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2019.03.27 18:44:32 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 6.7.1.35068 / 426519346f51f7b980a76f9050f983110550509d
2019.03.27 18:44:32 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false&serverTimezone=UTC
2019.03.27 18:44:33 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: D:\sonarqube-6.7.1
2019.03.27 18:44:33 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2019.03.27 18:44:34 ERROR web[][o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Can not check that table schema_migrations exists
at org.sonar.db.DatabaseUtils.wrapSqlException(DatabaseUtils.java:326)
at org.sonar.db.DatabaseUtils.tableExists(DatabaseUtils.java:321)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:44)
at java.util.Optional.ifPresent(Unknown Source)
at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:86)
at org.sonar.server.platform.Platform.start(Platform.java:211)
at org.sonar.server.platform.Platform.startLevel2Container(Platform.java:177)
at org.sonar.server.platform.Platform.init(Platform.java:87)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:62)
at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getTables(DatabaseMetaDataUsingInfoSchema.java:835)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.sonar.db.DatabaseUtils.tableExists(DatabaseUtils.java:312)
... 16 common frames omitted

...全文