安装文件Openfire\conf下的openfire.xml的serverURL改成这个jdbc:mysql://192.168.0.109:3306/openfire?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf-8
用界面安装时
jdbc:mysql://192.168.0.109:3306/openfire?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf-8