yum install java libldb.i686 mysql-server mysql-connector-java

创建数据库

create database openfire default character set utf8 default collate utf8_general_ci;

mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

grant all on openfire.* to root@localhost identified by ‘dddddd’;

将所有权限 openfire数据库的 赋予 root 本地登陆（loaclhost替换成% 指所有远程登陆。） 密码 dddddd

flush privileges;

安装openfire配置即可

jdbc:mysql://localhost:3306/openfire?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf8