Dan Jacobson schrieb:
php rebuildtextindex.php
ALTER TABLE... 1142: ALTER command denied to user...
< You do not have the right MySQL permissions. Add to your wikiuser
< account the ALTER TABLE privilege and your problems should be fixed.
And indeed they were. Now let's try another script.
$ php updateSearchIndex.php
LOCK TABLES... 1044: Access denied for user...
And indeed, adding more privileges fixes that too.
My question is why doesn't update.php fix or at least warn about
these? E.g., "Bla lacks permissions to do ZZZ. Some maintenance
scripts won't run. Some daily tasks will be hindered."
By the way on
http://meta.wikimedia.org/wiki/Help:How_to_move_a_wiki_to_another_server
"SELECT, INSERT, UPDATE and DELETE permissions should suffice."