url="jdbc:mysql://localhost:3306/confluence?useUnicode=true&characterEncoding=utf8"

[Oliver Das]

This question is in reference to Atlassian Documentation: Configuring a MySQL Datasource in Apache Tomcat

is incorrect. It should be:

url="jdbc:mysql://localhost:3306/confluence?useUnicode=true&characterEncoding=utf8"

otherwise error:

The reference to entity "characterEncoding" must end with the ';' delimiter.

is shown in the Catalina log and Tomcat does not work.

[Pierre Zurmely]

I do have the same issue on ubuntu.

Solution is described here:

https://bugs.mysql.com/bug.php?id=8496

You need to have this line:

ysql://localhost:3306/confluence?useUnicode=true&characterEncoding=utf8"

[Erdem Seherler]

url="jdbc:mysql://localhost:3306/confluence?useUnicode=true;characterEncoding=utf8;" worked for me at macOS