Wikimedia

Update to wheezy

If, after upgrading from debian squeeze to wheezy you get this error while running the wikimedia update.php script:

from within function "DatabaseBase::sourceFile( /usr/share/mediawiki/maintenance/archives/patch-user_properties.sql )".
Database returned error "1142: CREATE command denied to user 'wikiuser'@'localhost' for table 'user_properties' (localhost)"

Then you can fix it using

$ mysql -u root -p
mysql> grant alter, index, create on `wikitech`.* to 'wikiuser'@'localhost';

The error above is only about the missing create grant, but after fixing that the update.php script will complain about missing index, alter grants, so the above command will fix everything in one go.

test: $i$