Using MySql with Jahia on Debian GNU/Linux

After installing Jahia today, I wanted to use the MySql database instead of the default HyperSonic. I am currently using MySql for other purposes and want to have a look at accessing the Jahia database to re-use content.

Initially when I created the ‘jahia’ database in mysql and granted permissions to the Jahia user, Jahia reported:

"This database doesn't seem to support extended charsets."

Dropping the database and recreating it with a unicode dataset sorts this little niggle out.

mysql> create database jahia character set = utf8;