Problem connecting mySQL database to confluence server

[yilun you]

I'm having problems connecting to mysql from confluence server. I've used instructions listed here: https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

MySQL version: mysql-installer-web-community-8.0.11.0

MySQL Driver version: mysql-connector-java-8.0.11.tar

Confluence version: atlassian-confluence-6.8.1-x64

Error when setting up database:

Problem connecting to your database

SQLState - S1000
java.sql.SQLException: Illegal operation on empty result set.

it's not in your known list of issues: https://confluence.atlassian.com/confkb/known-issues-for-mysql-13138.html

[Nic Brough -Adaptavist-]

MySQL 8 is not yet supported by Confluence, please use 5.6 or 5.7 as listed on https://confluence.atlassian.com/doc/supported-platforms-207488198.html