Le 26/11/2013 12:37, Martin Hamant a écrit :
Hi!
I am running Xwiki 5.2 and trying to create a new wiki from the Wiki
Manager.
If fails with the following message in container logs: Access denied
for user 'xwiki'@'localhost' to database 'ezr' (where
'ezr' is the
wiki name).
I verified my installation reading the steps specified here :
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
My guess is the 'xwiki' user can't create a new database : what if the
official documentation about xwiki MySQL user for multi-tenant usage ?
Do I have to modify something in MySQL privileges ?
Here is the resulting privileges of "grant all privileges on xwiki.*
to xwiki@localhost identified by 'xxx'"
+--------------------------------------------------------------------------------------------------------------+
| Grants for xwiki@localhost |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xwiki'@'localhost' IDENTIFIED BY PASSWORD
'***' |
| GRANT ALL PRIVILEGES ON `xwiki`.* TO 'xwiki'@'localhost' |
+--------------------------------------------------------------------------------------------------------------+
From my understanding of the above , xwiki user only have all
privileges access to xwiki db... So the user can't create any
additional xwiki database !?
Thanks !
Answering to my own question : Found the answer here :
http://manager.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallXEM…
Convert an existing XWiki Enterprise instance
* In order for XEM to be able to create new wikis on demand, you will
need to give all rights to your database user. For example for
MySQL, execute:
mysql -u root -e "grant all privileges on *.* to xwiki(a)127.0.0.1
identified by 'xwiki'"
This step is required. (I am using DEB distribution of XWiki.)
Maybe this could be reminded somewhere on
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL ??
What do you think ?