Bitbucket Server fails to connect to external database - The target database is not configured for UTF-8 support
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
Bitbucket Server fail to connect to MySQL database. The following appears on the UI:
1
2
3
4
The target database is not configured for UTF-8 support. For information
about creating a database for use with Bitbucket Server, please refer to the Bitbucket Server
documentation.If you continue having issues, get in touch with our support team and we'll help get you up and running.
Show detailsCause
When creating the Bitbucket Server external database, incorrect character set and collation were used.
Resolution
To fix the error message, please make sure you configured the correct character set (UTF-8) required by Bitbucket Server at the database creation time. There are instructions on how you should perform that within each of the documents below:
1
2
3
# Make sure your MySQL database is configured as the document above -> utf8 character set encoding and utf8_bin collation
show variables like "character_set_database";
show variables like "collation_database";Was this helpful?