安装文件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
原文:http://blog.csdn.net/danny35/article/details/41444903