Last modified: 2009-09-14 01:28:09 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T22634, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 20634 - mySQL user lacks "create table" privilege.
mySQL user lacks "create table" privilege.
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.16.x
All All
: Normal major with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-09-13 23:36 UTC by Purodha Blissenbach
Modified: 2009-09-14 01:28 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Purodha Blissenbach 2009-09-13 23:36:05 UTC
The script maintenance/update.php is used to create missing tables at times, in addition
to many other tasks. The three wiki database mysql users automatically created during
installation do not have the "create table" privilege in the wiki database, thus the
"crate table" SQL command fails, as this console log shows:

...change_tag_rc_tag key already set on change_tag table.
Creating translate_sections table...En dä Syntax vun enem Befähl för de Daatebank es
ene Fähler es opjefalle.
Dä letzte Befähl för de Daatebank es jewäse:
<blockquote><code>CREATE TABLE `testwiki_translate_sections` (
 trs_page int unsigned NOT NULL,
 trs_key varchar(255) binary NOT NULL,
 trs_text mediumblob NOT NULL,
 PRIMARY KEY (trs_page, trs_key),
 KEY trs_page (trs_page)
 ) ENGINE=InnoDB, DEFAULT CHARSET=binary
</code></blockquote>
un kohm us däm Projramm singe Funktion: „<code>DatabaseBase::sourceStream</code>“.
De Datebank meld dä Fähler: „<code>1142: CREATE command denied to user 'wikiuser'@'localhost' for table 'testwiki_translate_sections' (localhost)</code>“.
Comment 1 Chad H. 2009-09-14 00:00:41 UTC
You're supposed to set $wgDBadminuser and $wgDBadminpassword in LocalSettings with the info of a user who has these privileges.
Comment 2 Aryeh Gregor (not reading bugmail, please e-mail directly) 2009-09-14 00:03:03 UTC
(In reply to comment #1)
> You're supposed to set $wgDBadminuser and $wgDBadminpassword in LocalSettings
> with the info of a user who has these privileges.

Why aren't these users also created automatically, and the variables populated?  This at least seems like a legitimate feature request.  You shouldn't have to manually fiddle with files to get upgrading to work.  Frankly, I don't see any serious reason why the normal user couldn't be given full privileges on the database, or certainly stuff like CREATE TABLE and ALTER TABLE.
Comment 3 Emufarmers 2009-09-14 01:28:09 UTC
Fixed in r56285.  This won't do anything for existing users, of course.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links