Thanks, Sergiu, Sergiu Dumitriu wrote:
Sometimes the connection comes from 127.0.0.1, not from localhost. Although they're actually the same thing, it seems that mysql doesn't do a normalization of the host. Or something else, maybe an alias of the host. Anyway, you could connect to the mysql server from a console and run "show processlist;" to see which hostname is printed for the connections from XWiki.
Here the output of "show processlist;" RicardoRodriguez@peat:~> mysql -u xwiki -p -e "show processlist" Enter password: +-----+-------+-----------------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-------+-----------------+-------+---------+------+-------+------------------+ | 100 | xwiki | localhost:37677 | xwiki | Sleep | 4 | | NULL | | 135 | xwiki | localhost | NULL | Query | 0 | NULL | show processlist | +-----+-------+-----------------+-------+---------+------+-------+------------------+ RicardoRodriguez@peat:~> It keeps been a mystery for me what is happening with that error when installing/using XEM. Something related with If XWiki generates tcp packets going in and out lo, it is clear that it is not using sockets but tcp. But these packets are from/to localhost so, why 'xwiki'@'localhost' with all privileges is not able to create schemas on demand? Just trying to understand what is going on here and if it could be of any importance for XWiki development. Thanks for your help! Ricardo -- Ricardo RodrÃguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems