Health Check Collation Issue for Mysql 5.7+ (Jira 8.4.1)

Yi Jin Lim

Health check problems detected:

Database: The table collation: 'utf8_bin' is unsupported by Jira. The Database collation: 'utf8mb4_bin' is supported by Jira.

 

I have run thru the guide according to below link.

 https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html 

 

However same Problem is detected during Health Check. 

Yi Jin Lim

More info below.

Executed this code in Mysql databse:

SHOW GLOBAL VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'; 

 

Output: 

character_set_client	utf8mb4
character_set_connection	utf8mb4
character_set_database	utf8mb4
character_set_filesystem	binary
character_set_results	utf8mb4
character_set_server	utf8mb4
character_set_system	utf8
collation_connection	utf8mb4_bin
collation_database	utf8mb4_bin
collation_server	utf8mb4_bin