安装二代XWiKi，安装MySql，正常运行XWiKi，见文章CentOS上安装运行XWiKi和xwiki使用指南。安装的数据库版本是5.6。遇到的问题是XWiKi的管理模块没有加载。
1.修改XWiKi连接的数据库为自己安装的MySql数据库，修改MySql数据库的存放路径为其它磁盘。
修改XWiKi连接的数据库配置文件：vim /usr/local/XWiki/webapps/xwiki/WEB-INF/hibernate.cfg.xml。注释掉默认hsqldb数据，放开MySQL的注释。
下载MySQL JDBC Driver Jar放到***/xwiki_tomcat/webapps/xwiki/WEB-INF/lib目录下：
wget http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.34/mysql-connector-java-5.1.34.jar
2.若刚装好数据库，没有任何修改，输入mysql回车就打开了数据库了（默认无密码登录）。也可以使用/usr/bin/mysql -u root mysql回车打开数据库。
执行修改数据库root密码语句：update user set password=password("12345") where user="root";和flush privileges;。用ps -ef | grep -i mysql回车查找是否安装数据库。
使用show databases;查看数据信息：
mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | xwiki | +--------------------+ 4 rows in set (0.00 sec)
3.若已经修改root密码，就用命令登录：mysql -u root -p;，输入密码并回车。若你设置了root密码，你再用/usr/bin/mysql -u root mysql;回车登录，将报下面的错误：
2018-12-17 17:26:27.430:INFO:oxtjl.NotifyListener:Thread-1: Done! [root@localhost xwiki]# /usr/bin/mysql -u root mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
4.切换到mysql数据库use mysql;。
5.创建xwiki数据库create database xwiki default character set utf8 collate utf8_bin;。
查看所有的数据库信息：。
6.对xwiki数据库设置密码update user set password=password("12345") where user="xwiki";。
可以用select * from user where User = 'xwiki';查看你新建的数据库的用户信息。
7.对xwiki数据库进行授权grant all privileges on *.* to xwiki@localhost identified by '12345'和flush privileges;。
若像有些文章中执行的是错误的命令：grant all privileges on xwiki.* to xwiki identified by 'xwiki';。那么你连接数据库时报下面的错误：
[root@localhost bin]# mysql -u xwiki -p; Enter password: ERROR 1045 (28000): Access denied for user 'xwiki'@'localhost' (using password: YES)
这个错误坑我很久。
下面是一个正常的操作的例子：
root@localhost bin]# mysql -u root -p; Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 Server version: 5.6.42 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> grant all privileges on *.* to xwiki@localhost identified by 'hzbit56771010'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye
8.使用xwiki用户登录数据库，可以看到登录正常了。
[root@localhost bin]# mysql -u xwiki -p; Enter password: ERROR 1045 (28000): Access denied for user 'xwiki'@'localhost' (using password: NO) [root@localhost bin]# mysql -u xwiki -p; Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 32 Server version: 5.6.42 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> quit Bye
9.切换到XWiKi目录cd /usr/local/XWiki，启动XWiKi./start_xwiki.sh回车。
你发现启动XWiKi成功，也不报错误。打开XWiKi主页：http://192.168.1.156:8180/xwiki/bin/view/Main/。看到的是一个没有管理模块的主页。
10.打开侧边栏以超级管理员登录，然后点击管理员设置，看到是这个错误警告。
查找文章：
You need to edit WEB-INF/cache/infinispan/config.xml for each instance of XWiki. For Infinispan up till version 6, change the jmxDomain value (found under the globalJmxStatistics tag) to have a unique name, or add allowDuplicateDomains="true" attribute for globalJmxStatistics element. For Infinispan version 7, add <jmx duplicate-domains="true"/> element in <cache-container... element.
修改后按照提示导包后，报这样的警告，还是没有管理页面，没有管理页面怎么增加用户啊，愁人啊！
参看XWiKi官方安装文档， MySQL Installation。
暂时没有找到很好的解决方案。只能先用着二代安装的XWiK和它的默认数据库吧！
