why do i use mysql 5.7 is no work for jira 8.13 and 8.17

[X]

i config mysql 5.7 ,and jira notice me my databases version is  no support version

The database setup is not supporting utf8mb4
See our documentation for more information on setting up MySQL 5.7

why ?

and i config jira 8.17 ,use mysql 8 ,and jira install ,create database and create tables

2021-06-16 21:44:44,438+0800 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "issueswithvalue" to table "customfield"
2021-06-16 21:44:44,438+0800 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE customfield ADD issueswithvalue DECIMAL(18,0)
Error was: java.sql.SQLSyntaxErrorException: Table 'jiradb2.customfield' doesn't exist
 

[Dirk Ronsmans]

Hi @X ,

did you do the step "See our documentation for more information on setting up MySQL 5.7"

Seems you have created the DB with the wrong table collation.

You can follow the steps here: 

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

[X]

i have to follow jira install step to do , mysql 5.7 or mysql 8.0 have set utf8mb4 and utf8mb4_bin,but jira alway show me error...

why??

[Dirk Ronsmans]

And where are you seeing the error? during the install? in a healthcheck?

I don't think I fully understand your problem.

You should create the DB, set the collation (preferably at time of creation) and then run the setup.

a screenshot can also help ..

[X]

i init jira 8.17,use mysql 8

jira just create three table , and to error, over init

web redirect /secure/errors.jsp,it's empy page

why