dbconfig.xml defaultDS default mysql57 jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB com.mysql.jdbc.Driver jiradbuser password 20 20 30000 20 true 300 select 1 60000 300000 true false 3 issue description： i upgrade jira 8 to 9.3.0 if i change dbconfig.xml mysql57 to mysql error "Database: We've found an error in MySQL supported version!" will disappear but error can not connect mysql still there

Are there any instructions for updating the database to MySQL 8.x? I'm currently using Jira 9.1 and MySQL 5.7 so cannot upgrade Jira to a newer version until MySQL is updated. The online documentation I've found hasnt helped with this task. Thanks

thanks , in 8.0 plan upgrade health check ,mysql 5.7 has passed the check.So there made a misunderstanding .i will upgrade my database

Hi @bowen chen , lib seems ok. Btw, based on https://confluence.atlassian.com/adminjiraserver0903/supported-platforms-1167688915.html JIRA9.3 doesn't support MySQL 5.7 and it means that you need to upgrade your MySQL to 8.0. Fabio

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

upgrade jira 9.3 mysql 5.7 can not connect

bowen chen_wxyr30

dbconfig.xml

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

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql57</database-type>
<jdbc-datasource>
<url>jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>jiradbuser</username>
<password>password</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

<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-test-while-idle>true</pool-test-while-idle>
<pool-test-on-borrow>false</pool-test-on-borrow>
<validation-query-timeout>3</validation-query-timeout>
</jdbc-datasource>
</jira-database-config>