Hello,
I'm trying to setup confluence and mysql Docker containers.
I have them both building successfully but when I try to set up confluence, I get this error:
Incorrect character set
Your database must be configured to use utf8 as the default character set. Learn more
I've specified the character set in the docker-compose file like this:
command: [mysqld, --character-set-server=utf8, --collation-server=utf8_bin, --default-storage-engine=INNODB, --max_allowed_packet=256M, --innodb_log_file_size=2GB, --transaction-isolation=READ-COMMITTED, --binlog_format=row]
I've also tried setting it in the database url like this:
jdbc:mysql://mysql/db?useUnicode=true&characterEncoding=utf8
Any help would be much appreciated!
I was able to resolve this issue myself. I had added the character-set-server and collation-server to the mysqld command in the docker-compose.yml file but for some reason that wasn't being used in the rebuild when using docker-compose up. Being as I am just getting started and had nothing in the database, I was able to remove the shared folder on the host that contained all the mysql files and used docker-compose up --force-recreate which resolved the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.