Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence 6.15.1 installation issue with MySQL 5.7.27

Hi Team,

I'm trying to install the Jira & Confluence on the same Ubuntu machine, here I given the version details.

Ubuntu 16.04
Java 1.8.0_222
MySQL 5.7.27
Jira 8.4.2
Confluence 6.15.1

I did Jira MySQL installation with characterEncoding as utf8mb4 successfully.
Now while I'm trying for Confluence setup it is asking me to change the characterEncoding as utf8. 

What should I need to change the configuration in process to achieve this task?
If I configure both Jira & Confluence on same machine on same MySQL database what will be the issue?
Which are the best versions to be configure on Ubuntu 16.04 without issues?
I've license keys for these products.
Please find the screenshot.Incorrect data set.PNG

2 answers

0 votes
Alexis Robert Community Leader Oct 09, 2019

Hi @Sambit_Kumar_Patra , 

 

Jira and Confluence use a different character encoding, this should be setup when you create  the database.

For Confluence :

CREATE DATABASE confluencedb CHARACTER SET utf8 COLLATE utf8_bin;

For Jira :

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

 

You don't need to change the entire MySQL server default setting as it can be set for each database that you create.

For Confluence, this guide can be useful for MySQL setup : https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html#DatabaseSetupForMySQL-3.Createdatabaseanddatabaseuser

 

Let me know if this helps, 

 

--Alexis

One remark:

If the database & the tables already exists, it is NOT sufficient to just change the character set / collation for the database. Every table MUST be converted to the new settings on it's own.

Best

JP

Like Sambit_Kumar_Patra likes this

@Alexis Robert @JP _AC Bielefeld Leader_ 
Thank you both the people, it helped me alot

Alexis Robert Community Leader Oct 11, 2019

Good to know @Sambit_Kumar_Patra , if you don't mind clinking on Accept Answer on the first post it will help users can also find this solution later, when they have the same issue :)

 

Thanks !

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

494 views 24 9
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you