MySQL 8.2 Startup Failure - dbconfig.xml is set up to MySQL 8.0 and your MySQL version is different

[Mike Whalen]

Is MySQL 8.2 supported for Jira 9.10?

Failure at startup - GUI message is:

Database: We've found an error in MySQL supported version!

The database type in your dbconfig.xml is set up to MySQL 8.0 and your MySQL version is different. Consider using MySQL 8.0 database type instead
See our documentation for more information on changing database type.

mysql --version

mysql  Ver 8.2.0 for macos14.0 on x86_64 (Homebrew)

dbconfig.xml (changing from mysql8 to mysql8.2 or mysql82  made it worse):

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>

  <name>defaultDS</name>

  <delegator-name>default</delegator-name>

  <database-type>mysql8</database-type>

  <jdbc-datasource>

    <url>jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/jiradb?sessionVariables=default_storage_engine=InnoDB</url>

    <driver-class>com.mysql.cj.jdbc.Driver</driver-class>

    <atlassian-password-cipher-provider>com.atlassian.db.config.password.ciphers.base64.Base64Cipher</atlassian-password-cipher-provider>

    <username>PRIVATE</username>

    <password>PRIVATE</password>

    <pool-min-size>40</pool-min-size>

    <pool-max-size>40</pool-max-size>

    <pool-max-wait>30000</pool-max-wait>

    <validation-query>select 1</validation-query>

    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>

    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>

    <pool-max-idle>40</pool-max-idle>

    <pool-remove-abandoned>true</pool-remove-abandoned>

    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

    <pool-test-on-borrow>false</pool-test-on-borrow>

    <pool-test-while-idle>true</pool-test-while-idle>

    <validation-query-timeout>3</validation-query-timeout>

    <connection-properties>nullDatabaseMeansCurrent=true</connection-properties>

  </jdbc-datasource>

</jira-database-config>

[BHUSHAN PATIL]

Hi @Mike Whalen ,

According to Atlassian's official documentation, MySQL 8.0 is the supported version for Jira 9.10. MySQL 8.2 isn't listed as a supported version for that specific Jira release i.e jira 9.10.

you can also refer Jira databases compatibility matrix

The error message you're encountering, "Database: We've found an error in MySQL supported version!", could indeed be related to the MySQL collation compatibility with Jira's recommended settings for MySQL 8.0.

• MySQL Database Collation health check fails in Jira server
• How to Fix the Collation and Character Set of a MySQL Database manually

I would recommend first verifying the collation settings in your MySQL 8.2 database and configure the collation settings to match the Atlassian recommended configuration for MySQL 8.0 might resolve the error you're encountering during Jira startup.

Also, if you feel my input help you please accept the answer.

Regards,
Bhushan

[ChristianWaidner]

Sadly Atlassian currently doesn't support MySQL 8.2 - I discovered the same problem after trying to migrate one of my instances ...