Re: [Semediawiki-user] Problem with installing semantic mediawiki

[S P. <in...@sk...>]

Paul van den Berg wrote:
> Hi,
> I login as user ‘Paul’ which has admin rights.
> 
> Then I go to the Speciaal:SMWAdmin page and click the button.
> 
> I get the next error :
> 
> Setting up standard database configuration for SMW ...
> Setting up table `smw_relations` ...
> *http://paul-laptop/WPS%20logo.png**Database error*
>                A database query syntax error has occurred.
> This may indicate a bug in the software.
> The last attempted database query was:
> (SQL query hidden)
> 
> from within function "SMWSQLStore::setupTable".
> 
> MySQL returned error "1142: CREATE command denied to user 
> 'Paul'@'localhost' for table 'smw_relations' (localhost)".
> 
> Any ideas how I can fix this?

I had similar problems when I first set up MediaWiki and SMW.

You should check the permissions in MySQL of the database user (NOT the 
MediaWiki user) as whom MediaWiki connects to MySQL.  Look in your 
MediaWiki LocalSettings.php for 
$wgDBserver/$wgDBname/$wgDBuser/$wgDBpassword/$wgDBprefix} then use 
something like phpMyAdmin's _Privileges_  to check that user's 
privileges.  It sounds like your $wgDBuser is named "Paul" which is also 
one of your MediaWiki user accounts.

I ended up having to create several flavors of my MediaWiki DB user 
"wikiuser" on different Hosts: wikiuser on Host %, wikiuser on 
localhost, and wikiuser on localhost.domain, all with Global privileges 
of "USAGE".

This might not be your problem at all,, but something in the area of 
Privileges and database users seems amiss.  Read more at 
http://www.mediawiki.org/wiki/Manual:Installation#MySQL

--
=S Page