Openfire安装，支持中文，支持Unicode

1.       输入命令建表

CREATE DATABASE `openfire` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

 

2.       在mysql配置页面中的“the URL of the JDBC driver 列”的后面加入

?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8

 

3.       其他按照页面继续操作。

 

参考官网文档：

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database.html

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY ''WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;