Re: [xwiki-users] XWiki 8 failure to add new wiki - Access denied for user 'xwiki'@'%'

On 17 Aug 2016, at 18:17, Tim.Jones <tim.jones.001(a)gmail.com> wrote: Created a new 8.2.1 wiki using mysql and tomcat 7 and initial user (created by the distribution wizard) seems unable to create a new wiki despite being part of the admin group, which was granted "create wiki" right and also being given "create wiki" right in the administration app. The salient error seems to be: *Access denied for user 'xwiki'@'%' to database 'wikiweb'* (where wikiweb was the new wiki name) the 'xwiki'@'localhost' mysql user has all privileges on *.*, so this does not seem to be the problem - could anyone shed any light on what the problem might be or what I could look at?

Thanks Tim The full set of error messages are below: Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/wikiweb] Access denied for user 'xwiki'@'%' to database 'wikiweb' class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:102) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to create the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:54) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.wiki.manager.WikiManagerException: Failed to create database for wiki "wikiweb" at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:69) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class com.xpn.xwiki.XWikiException: Error number 3401 in 3: Exception while create wiki database wikiweb at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:338) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'%' to database 'wikiweb' at sun.reflect.GeneratedConstructorAccessor167.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:320) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Finished job of type [wikicreationjob] with identifier [wikicreation/createandinstall/wikiweb] -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-8-failure-to-add-new-wiki-Access-de… Sent from the XWiki- Users mailing list archive at Nabble.com.