Thread:Project:Support desk/Database Access Problem

I had a problem with the MYSQL user. I created the user like it is explained on the site Manual:Installing_MediaWiki/de#MySQL:

grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password'; flush privileges;

But I also use SemanticMediaWiki and had the error message:

Es ist ein Datenbankfehler aufgetreten. Der Grund kann ein Programmierfehler sein. Die letzte Datenbankabfrage lautete: (SQL-Abfrage versteckt) aus der Funktion „SMW::executeQueries“. Die Datenbank meldete den Fehler „1044: Access denied for user 'wikiuser'@'localhost' to database 'wikidatabase' (localhost)“.

After editing the privileges of the wikiuser:

grant create temporary tables  on wikidatabase.* to 'wikiuser'@'localhost'; flush privileges;

The Mediawiki works fine.

I googled a long time, but didn't find anything about this Problem. Maybe this is only a problem of SemanticMediaWiki?

If someone has the same problem, I hope my post will help.

Versions:
 * MediaWiki 	1.16.1
 * PHP 	       5.3.3-7+squeeze3 (apache2handler)
 * MySQL 	       5.1.49-3