MySQL Collation Error When Starting-up Server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
The following message is shown when starting up Fisheye/Crucible:
1
INFO \| jvm 1 \| 2010/10/19 09:41:25 \| 09:41:25 ERROR - MySQL DB is using collation 'utf8_general_ci'
Cause
Fisheye/Crucible needs to use rules for comparing string values which recognise the differences between upper and lower case letters. Hence, a database with "case sensitive collation" is required.
Resolution
The database collation needs to be changed. Please refer to the following page for instructions:
Was this helpful?