Mysql upgraded from 5.7 to 8.0 and Sonarqube 7.8 not starting GUI

Hello Team,

We have migrated the Mysql from 5.7 to 8.0 which has already installed and working sonarqube 7.8, after migrated to Mysql 8.0 version GUI not loading and after 1 minutes sonarqube process stopped.

Please help on this below error in web.log

2023.12.25 06:24:05 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2023.12.25 06:24:05 ERROR web[o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'empty,

  text_value as value,
  created_at as createdAt
from
  i' at line 3

The error may exist in org.sonar.db.property.InternalPropertiesMapper

The error may involve org.sonar.db.property.InternalPropertiesMapper.selectAsText-Inline

The error occurred while setting parameters

SQL: select kee as “key”, is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? )

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'empty,

  text_value as value,
  created_at as createdAt

SonarQube 7.8 doesn’t work with MySQL file, as described in the default sonar.properties file:

#----- MySQL >=5.6 && <8.0

Source: sonarqube/sonar-application/src/main/assembly/conf/sonar.properties at 870ae4efbf5dcdbe59295eb5827b55a6a74c7b89 · SonarSource/sonarqube · GitHub

Also note: End of Life of MySQL Support

Felipe Zorzo, Thanks for the quick reply.