Summary

With https://jira.atlassian.com/browse/JRASERVER-36135 we began officially supporting the MySQL 5.7 with the utf8mb4 collation.

The documentation can be found here: Connecting Jira applications to MySQL 5.7

However, using this supported platform in Jira 8 still prompts the following Health Check warning:

Your mysql database is currently using an unsupported collation: utf8mb4_bin. You should change this to a supported collation: utf8_bin

Environment

• Jira 8.0
• MySQL 5.7 using utf8mb4_bin as outlined in Connecting Jira applications to MySQL 5.7

Steps to Reproduce

1. Install Jira 8
2. Set database-type to mysql in dbconfig.xml ( this is not correct )
3. Setup MySQL 5.7 as outlined in Connecting Jira applications to MySQL 5.7

Expected Results

Jira 8 runs using the supported database collation without errors.

Actual Results

The following error is thrown on startup:

Your MySQL database is currently using an unsupported collation: utf8mb4_bin. You should change this to a supported collation: utf8_bin

Screenshot:

Fix

To resolve the issue, you can run config.sh/bat to update your dbconfig.xml, or manually change database-type from mysql to mysql57 in your dbconfig.xml file.

This is discussed in Connecting Jira applications to MySQL 5.7

Only works in JIRA 8.