Wikimedia Bugzilla is closed!

Oops. Sorry. I DO have the LocalSettings file. 
All the rest was a prolem but I do have the file.

Read the installer page a little more carefully. If the database user does not
exist or have access to create tables, MediaWiki will attempt to use a specified
superuser account. To indicate that this should not be the case, leave the
superuser password set to -, which is the default.

Closing WORKSFORME.

He says, hitting the wrong button...reopening to correct resolution.

You're missing the point. I read the page very carefully. MySQL did not read the
instructions at all.

The database existed. I therefore didn't set the root password. Everything
worked up to the point opf the transcache table and then, suddenly, my user
stopped having authorization. It was a right royal mess.

In otherwords, following the instructions didn't work because MySQL kept blowing up

mySQL complained that the user used to connect to the database didn't have
create permissions? Had the installer attempted to create tables prior to that
point? Did said user, in fact, have those permissions?

That's the weird part.

As I said in the original report, I created a mediawiki installation. All went
well. Then I tried to create a second installation.

I used the same MySQL user (created by the previous installation) and the same
database (created by the previous installation) with a different table prefix.

The first time I tried this, "root" didn't have privs. I tried again w/o root.
The second time, the user worked fine until it was time to create the transcache
table; then, suddenly and inexplicably, the user no longer had create table privs.
I tried again with root. This time all went through to the end.

I never meant to imply this was an easy problem with a quick solution :-)

Did the user have permission? Yes, until it no longer had permission.  Don't ask
me why the privs went away; I haven't a cluse.

The database, the user, and the GRANT Privileges etc... were all performed by
the mediawiki installation (the first one).

I don't reall y care if it works for you.


Here's a sample in a Brand New installation

First, it ran like this:

MediaWiki 1.5.6 installation

Checking environment...

    * PHP 4.3.9: ok
    * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * PHP is configured with no memory_limit.
    * No zlib support.
    * Neither Turck MMCache nor eAccelerator are installed, can't use object
caching functions
    * GNU diff3 not found.
    * Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be
enabled if you enable uploads.
    * Installation directory:
/ad4/ENV/cfcl/usr_local/Server/WWW/web/technofile/mediawiki
    * Script URI path: /mediawiki
    * Connecting to tf_wikidb on localhost as root...success.
    * Connected to 4.1.7-standard; using enhancements for mySQL 4.
    * Created database tf_wikidb
    * Creating tables... using MySQL 3/4 table defs... done.
    * Initializing data...A database error has occurred Query: SELECT user_id
FROM `tf_user` WHERE user_name = 'WikiSysop' LIMIT 1 Function: User::idFromName
Error: 1142 select command denied to user 'wikiuser'@'localhost' for table
'tf_user' (localhost) Backtrace: GlobalFunctions.php line 451 calls
wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php
line 347 calls databasemysql::reportqueryerror() Database.php line 723 calls
databasemysql::query() Database.php line 742 calls databasemysql::select()
User.php line 150 calls databasemysql::selectrow() User.php line 74 calls
user::idfromname() index.php line 645 calls user::newfromname() 
    


Then I tried again:

Checking environment...

    * PHP 4.3.9: ok
    * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * PHP is configured with no memory_limit.
    * No zlib support.
    * Neither Turck MMCache nor eAccelerator are installed, can't use object
caching functions
    * GNU diff3 not found.
    * Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be
enabled if you enable uploads.
    * Installation directory:
/ad4/ENV/cfcl/usr_local/Server/WWW/web/technofile/mediawiki
    * Script URI path: /mediawiki
    * Connecting to tf_wikidb on localhost as root...success.
    * Connected to 4.1.7-standard; using enhancements for mySQL 4.
    * Database tf_wikidb exists
    * There are already MediaWiki tables in this database. Checking if updates
are needed...
    * DB user account ok

      ...hitcounter table already exists.
      ...querycache table already exists.
      ...objectcache table already exists.
      ...categorylinks table already exists.
      ...logging table already exists.
      ...validate table already exists.
      ...user_newtalk table already exists.
      Creating transcache table...ok
      ...trackbacks table already exists.
      ...have ipb_id field in ipblocks table.
      ...have ipb_expiry field in ipblocks table.
      ...have rc_type field in recentchanges table.
      ...have rc_ip field in recentchanges table.
      ...have rc_id field in recentchanges table.
      ...have rc_patrolled field in recentchanges table.
      ...have user_real_name field in user table.
      ...have user_token field in user table.
      ...have user_email_token field in user table.
      ...have log_params field in logging table.
      ...have ar_rev_id field in archive table.
      ...have ar_text_id field in archive table.
      ...have page_len field in page table.
      ...have rev_deleted field in revision table.
      ...have img_width field in image table.
      ...have img_metadata field in image table.
      ...have img_media_type field in image table.
      ...have val_ip field in validate table.
      ...have ss_total_pages field in site_stats table.
      ...have iw_trans field in interwiki table.
      ...already have interwiki table
      ...indexes seem up to 20031107 standards
      Already have pagelinks; skipping old links table updates.
      ...image primary key already set.
      The watchlist table is already set up for email notification.
      ...user table does not contain old email authentication field.
      Logging table has correct title encoding.
      ...page table already exists.
      revision timestamp indexes already up to 2005-03-13
      ...rev_text_id already in place.
      ...page_namespace is already a full int (int(11)).
      ...ar_namespace is already a full int (int(11)).
      ...rc_namespace is already a full int (int(11)).
      ...wl_namespace is already a full int (int(11)).
      ...qc_namespace is already a full int (int(11)).
      ...log_namespace is already a full int (int(11)).
      ...already have pagelinks table.
      No img_type field in image table; Good.
      Already have unique user_name index.
      ...user_groups table already exists.
      ...user_groups is in current format.
      Initialising "MediaWiki" namespace...
      A database error has occurred
      Query: SELECT page_title,page_is_new,rev_user_text FROM `tf_page`,
`tf_revision` WHERE
      		page_namespace=8 AND rev_page=page_id AND page_title
IN('1movedto2','1movedto2_redir','Monobook.css','Monobook.js','About','Aboutpage','Aboutsite','Accesskey-compareselectedversions','Accesskey-diff','Accesskey-minoredit','Accesskey-preview','Accesskey-save','Accesskey-search','Accmailtext','Accmailtitle','Acct_creation_throttle_hit','Actioncomplete','Addedwatch','Addedwatchtext','Addgroup','Addgrouplogentry','Addsection','Administrators','Allarticles','Allinnamespace','Alllogstext','Allmessages','Allmessagescurrent','Allmessagesdefault','Allmessagesname','AllmessagesnotsupportedDB','AllmessagesnotsupportedUI','Allmessagestext','Allnonarticles','Allnotinnamespace','Allpages','Allpagesfrom','Allpagesnext','Allpagesprev','Allpagessubmit','Alphaindexline','Already_bureaucrat','Already_steward','Already_sysop','Alreadyloggedin','Alreadyrolled','Ancientpages','And','Anontalk','Anontalkpagetext','Anonymous','Apr','April','Article','Articleexists','Articlepage','Aug','August','Autoblocker','Badaccess','Badaccesstext','Badarticleerror','Badfilename','Badfiletype','Badipaddress','Badquery','Badquerytext','Badretype','Badtitle','Badtitletext','Blanknamespace','Blockedtext','Blockedtitle','Blockip','Blockipsuccesssub','Blockipsuccesstext','Blockiptext','Blocklink','Blocklistline','Blocklogentry','Blocklogpage','Blocklogtext','Bold_sample','Bold_tip','Booksources','Booksourcetext','Brokenredirects','Brokenredirectstext','Bugreports','Bugreportspage','Bureaucratlog','Bureaucratlogentry','Bydate','Byname','Bysize','Cachederror','Cancel','Cannotdelete','Cantrollback','Categories','Categoriespagetext','Category','Category_header','Categoryarticlecount','Categoryarticlecount1','Changed','Changegrouplogentry','Changepassword','Changes','Clearyourcache','Columns','Compareselectedversions','Confirm','Confirmdelete','Confirmdeletetext','Confirmemail','Confirmemail_body','Confirmemail_error','Confirmemail_invalid','Confirmemail_loggedin','Confirmemail_send','Confirmemail_sendfailed','Confirmemail_sent','Confirmemail_subject','Confirmemail_success','Confirmemail_text','Confirmprotect','Confirmprotecttext','Confirmunprotect','Confirmunprotecttext','Contextchars','Contextlines','Contribs-showhideminor','Contribslink','Contribsub','Contributions','Copyright','Copyrightpage','Copyrightpagename','Copyrightwarning','Copyrightwarning2','Couldntremove','Createaccount','Createaccountmail','Createarticle','Created','Creditspage','Cur','Currentevents','Currentevents-url','Currentrev','Currentrevisionlink','Data','Databaseerror','Dateformat','Dberrortext','Dberrortextcl','Deadendpages','Debug','Dec','December','Default','Defaultns','Defemailsubject','Delete','Delete_and_move','Delete_and_move_reason','Delete_and_move_text','Deletecomment','Deletedarticle','Deletedrev','Deletedrevision','Deletedtext','Deleteimg','Deleteimgcompletely','Deletepage','Deletesub','Deletethispage','Deletionlog','Dellogpage','Dellogpagetext','Destfilename','Developertext','Developertitle','Diff','Difference','Disambiguations','Disambiguationspage','Disambiguationstext','Disclaimerpage','Disclaimers','Doubleredirects','Doubleredirectstext','Eauthentsent','Edit','Edit-externally','Edit-externally-help','Editcomment','Editconflict','Editcurrent','Editgroup','Edithelp','Edithelppage','Editing','Editingcomment','Editingold','Editingsection','Editsection','Editthispage','Editusergroup','Email','Emailauthenticated','Emailconfirmlink','Emailflag','Emailforlost','Emailfrom','Emailmessage','Emailnotauthenticated','Emailpage','Emailpagetext','Emailsend','Emailsent','Emailsenttext','Emailsubject','Emailto','Emailuser','Emptyfile','Enotif_body','Enotif_lastvisited','Enotif_mailer','Enotif_newpagetext','Enotif_reset','Enotif_subject','Enterlockreason','Error','Errorpagetitle','Exbeforeblank','Exblank','Excontent','Excontentauthor','Exif-aperturevalue','Exif-artist','Exif-bitspersample','Exif-brightnessvalue','Exif-cfapattern','Exif-colorspace','Exif-colorspace-1','Exif-colorspace-ffff.h','Exif-componentsconfiguration','Exif-componentsconfiguration-0','Exif-componentsconfiguration-1','Exif-componentsconfiguration-2','Exif-componentsconfiguration-3','Exif-componentsconfiguration-4','Exif-componentsconfiguration-5','Exif-componentsconfiguration-6','Exif-compressedbitsperpixel','Exif-compression','Exif-compression-1','Exif-compression-6','Exif-contrast','Exif-contrast-0','Exif-contrast-1','Exif-contrast-2','Exif-copyright','Exif-customrendered','Exif-customrendered-0','Exif-customrendered-1','Exif-datetime','Exif-datetimedigitized','Exif-datetimeoriginal','Exif-devicesettingdescription','Exif-digitalzoomratio','Exif-exifversion','Exif-exposurebiasvalue','Exif-exposureindex','Exif-exposuremode','Exif-exposuremode-0','Exif-exposuremode-1','Exif-exposuremode-2','Exif-exposureprogram','Exif-exposureprogram-0','Exif-exposureprogram-1','Exif-exposureprogram-2','Exif-exposureprogram-3','Exif-exposureprogram-4','Exif-exposureprogram-5','Exif-exposureprogram-6','Exif-exposureprogram-7','Exif-exposureprogram-8','Exif-exposuretime','Exif-filesource','Exif-filesource-3','Exif-flash','Exif-flashenergy','Exif-flashpixversion','Exif-fnumber','Exif-focallength','Exif-focallengthin35mmfilm','Exif-focalplaneresolutionunit','Exif-focalplaneresolutionunit-2','Exif-focalplanexresolution','Exif-focalplaneyresolution','Exif-gaincontrol','Exif-gaincontrol-0','Exif-gaincontrol-1','Exif-gaincontrol-2','Exif-gaincontrol-3','Exif-gaincontrol-4','Exif-gpsaltitude','Exif-gpsaltituderef','Exif-gpsareainformation','Exif-gpsdatestamp','Exif-gpsdestbearing','Exif-gpsdestbearingref','Exif-gpsdestdistance','Exif-gpsdestdistanceref','Exif-gpsdestlatitude','Exif-gpsdestlatituderef','Exif-gpsdestlongitude','Exif-gpsdestlongituderef','Exif-gpsdifferential','Exif-gpsdirection-m','Exif-gpsdirection-t','Exif-gpsdop','Exif-gpsimgdirection','Exif-gpsimgdirectionref','Exif-gpslatitude','Exif-gpslatitude-n','Exif-gpslatitude-s','Exif-gpslatituderef','Exif-gpslongitude','Exif-gpslongitude-e','Exif-gpslongitude-w','Exif-gpslongituderef','Exif-gpsmapdatum','Exif-gpsmeasuremode','Exif-gpsmeasuremode-2','Exif-gpsmeasuremode-3','Exif-gpsprocessingmethod','Exif-gpssatellites','Exif-gpsspeed','Exif-gpsspeed-k','Exif-gpsspeed-m','Exif-gpsspeed-n','Exif-gpsspeedref','Exif-gpsstatus','Exif-gpsstatus-a','Exif-gpsstatus-v','Exif-gpstimestamp','Exif-gpstrack','Exif-gpstrackref','Exif-gpsversionid','Exif-imagedescription','Exif-imagelength','Exif-imageuniqueid','Exif-imagewidth','Exif-isospeedratings','Exif-jpeginterchangeformat','Exif-jpeginterchangeformatlength','Exif-lightsource','Exif-lightsource-0','Exif-lightsource-1','Exif-lightsource-10','Exif-lightsource-11','Exif-lightsource-12','Exif-lightsource-13','Exif-lightsource-14','Exif-lightsource-15','Exif-lightsource-17','Exif-lightsource-18','Exif-lightsource-19','Exif-lightsource-2','Exif-lightsource-20','Exif-lightsource-21','Exif-lightsource-22','Exif-lightsource-23','Exif-lightsource-24','Exif-lightsource-255','Exif-lightsource-3','Exif-lightsource-4','Exif-lightsource-9','Exif-make','Exif-make-value','Exif-makernote','Exif-maxaperturevalue','Exif-meteringmode','Exif-meteringmode-0','Exif-meteringmode-1','Exif-meteringmode-2','Exif-meteringmode-255','Exif-meteringmode-3','Exif-meteringmode-4','Exif-meteringmode-5','Exif-meteringmode-6','Exif-model','Exif-model-value','Exif-oecf','Exif-orientation','Exif-orientation-1','Exif-orientation-2','Exif-orientation-3','Exif-orientation-4','Exif-orientation-5','Exif-orientation-6','Exif-orientation-7','Exif-orientation-8','Exif-photometricinterpretation','Exif-photometricinterpretation-1','Exif-photometricinterpretation-6','Exif-pixelxdimension','Exif-pixelydimension','Exif-planarconfiguration','Exif-planarconfiguration-1','Exif-planarconfiguration-2','Exif-primarychromaticities','Exif-referenceblackwhite','Exif-relatedsoundfile','Exif-resolutionunit','Exif-rowsperstrip','Exif-samplesperpixel','Exif-saturation','Exif-saturation-0','Exif-saturation-1','Exif-saturation-2','Exif-scenecapturetype','Exif-scenecapturetype-0','Exif-scenecapturetype-1','Exif-scenecapturetype-2','Exif-scenecapturetype-3','Exif-scenetype','Exif-scenetype-1','Exif-sensingmethod','Exif-sensingmethod-1','Exif-sensingmethod-2','Exif-sensingmethod-3','Exif-sensingmethod-4','Exif-sensingmethod-5','Exif-sensingmethod-7','Exif-sensingmethod-8','Exif-sharpness','Exif-sharpness-0','Exif-sharpness-1','Exif-sharpness-2','Exif-shutterspeedvalue','Exif-software','Exif-software-value','Exif-spatialfrequencyresponse','Exif-spectralsensitivity','Exif-stripbytecounts','Exif-stripoffsets','Exif-subjectarea','Exif-subjectdistance','Exif-subjectdistance-value','Exif-subjectdistancerange','Exif-subjectdistancerange-0','Exif-subjectdistancerange-1','Exif-subjectdistancerange-2','Exif-subjectdistancerange-3','Exif-subjectlocation','Exif-subsectime','Exif-subsectimedigitized','Exif-subsectimeoriginal','Exif-transferfunction','Exif-usercomment','Exif-whitebalance','Exif-whitebalance-0','Exif-whitebalance-1','Exif-whitepoint','Exif-xresolution','Exif-xyresolution-c','Exif-xyresolution-i','Exif-ycbcrcoefficients','Exif-ycbcrpositioning','Exif-ycbcrsubsampling','Exif-yresolution','Expiringblock','Explainconflict','Export','Exportcuronly','Exporttext','Externaldberror','Extlink_sample','Extlink_tip','Faq','Faqpage','Feb','February','Feedlinks','Filecopyerror','Filedeleteerror','Filedesc','Fileexists','Fileinfo','Filemissing','Filename','Filenotfound','Filerenameerror','Files','Filesource','Filestatus','Fileuploaded','Formerror','Friday','Geo','Getimagelist','Go','Googlesearch','Group-admin-desc','Group-admin-name','Group-anon-desc','Group-anon-name','Group-bureaucrat-desc','Group-bureaucrat-name','Group-loggedin-desc','Group-loggedin-name','Group-steward-desc','Group-steward-name','Groups','Groups-addgroup','Groups-already-exists','Groups-editgroup','Groups-editgroup-description','Groups-editgroup-name','Groups-editgroup-preamble','Groups-existing','Groups-group-edit','Groups-lookup-group','Groups-noname','Groups-tableheader','Guesstimezone','Headline_sample','Headline_tip','Help','Helppage','Hide','Hidetoc','Hist','Histfirst','Histlast','Histlegend','History','History_copyright','History_short','Historywarning','Hr_tip','Ignorewarning','Illegalfilename','Ilsubmit','Image_sample','Image_tip','Imagelinks','Imagelist','Imagelistall','Imagelisttext','Imagemaxsize','Imagepage','Imagereverted','Imgdelete','Imgdesc','Imghistlegend','Imghistory','Imglegend','Immobile_namespace','Import','Importfailed','Importhistoryconflict','Importinterwiki','Importnofile','Importnosources','Importnotext','Importsuccess','Importtext','Importuploaderror','Infiniteblock','Info_short','Infobox','Infobox_alert','Infosubtitle','Internalerror','Intl','Invalidemailaddress','Invert','Ip_range_invalid','Ipaddress','Ipadressorusername','Ipb_expiry_invalid','Ipbexpiry','Ipblocklist','Ipblocklistempty','Ipboptions','Ipbother','Ipbotheroption','Ipbreason','Ipbsubmit','Ipusubmit','Ipusuccess','Isbn','Isredirect','Italic_sample','Italic_tip','Iteminvalidname','Jan','January','Jul','July','Jun','June','Laggedslavemode','Largefile','Last','Lastmodified','Lastmodifiedby','Lineno','Link_sample','Link_tip','Linklistsub','Linkprefix','Linkshere','Linkstoimage','Linktrail','Listform','Listingcontinuesabbrev','Listusers','Loadhist','Loadingrev','Localtime','Lockbtn','Lockconfirm','Lockdb','Lockdbsuccesssub','Lockdbsuccesstext','Lockdbtext','Locknoconfirm','Log','Login','Loginend','Loginerror','Loginpagetitle','Loginproblem','Loginprompt','Loginreqtext','Loginreqtitle','Loginsuccess','Loginsuccesstitle','Logout','Logouttext','Logouttitle','Lonelypages','Longpages','Longpagewarning','Mailerror','Mailmypassword','Mailnologin','Mailnologintext','Mainpage','Mainpagedocfooter','Mainpagetext','Maintenance','Maintenancebacklink','Maintnancepagetext','Makesysop','Makesysopfail','Makesysopname','Makesysopok','Makesysopsubmit','Makesysoptext','Makesysoptitle','Mar','March','Markaspatrolleddiff','Markaspatrolledlink','Markaspatrolledtext','Markedaspatrolled','Markedaspatrolledtext','Matchtotals','Math','Math_bad_output','Math_bad_tmpdir','Math_failure','Math_image_error','Math_lexing_error','Math_notexvc','Math_sample','Math_syntax_error','Math_tip','Math_unknown_error','Math_unknown_function','May','May_long','Media_sample','Media_tip','Mediawarning','Metadata','Metadata_page','Minlength','Minoredit','Minoreditletter','Mispeelings','Mispeelingspage','Mispeelingstext','Missingarticle','Missingimage','Missinglanguagelinks','Missinglanguagelinksbutton','Missinglanguagelinkstext','Monday','Moredotdotdot','Mostlinked','Move','Movearticle','Movedto','Movelogpage','Movelogpagetext','Movenologin','Movenologintext','Movepage','Movepagebtn','Movepagetalktext','Movepagetext','Movereason','Movetalk','Movethispage','Mw_math_html','Mw_math_mathml','Mw_math_modern','Mw_math_png','Mw_math_simple','Mw_math_source','Mycontris','Mypage','Mytalk','Namespace','Namespacesall','Navigation','Nbytes','Nchanges','Newarticle','Newarticletext','Newbies','Newimages','Newmessages','Newmessageslink','Newpage','Newpageletter','Newpages','Newpassword','Newtitle','Newusersonly','Newwindow','Next','Nextdiff','Nextn','Nextpage','Nextrevision','Nlinks','Noarticletext','Noconnect','Nocontribs','Nocookieslogin','Nocookiesnew','Nocreativecommons','Nocredits','Nodb','Nodublincore','Noemail','Noemailprefs','Noemailtext','Noemailtitle','Nogomatch','Nohistory','Noimage','Noimages','Nolinkshere','Nolinkstoimage','Noname','Nonefound','Nonunicodebrowser','Nospecialpagetext','Nosuchaction','Nosuchactiontext','Nosuchspecialpage','Nosuchuser','Nosuchusershort','Notacceptable','Notanarticle','Notargettext','Notargettitle','Note','Notextmatches','Notitlematches','Notloggedin','Nov','November','Nowatchlist','Nowiki_sample','Nowiki_tip','Nstab-category','Nstab-help','Nstab-image','Nstab-main','Nstab-media','Nstab-mediawiki','Nstab-special','Nstab-template','Nstab-user','Nstab-wp','Numauthors','Number_of_watching_users_RCview','Number_of_watching_users_pageview','Numedits','Numtalkauthors','Numtalkedits','Numwatchers','Nviews','Oct','October','Ok','Oldpassword','Orig','Orphans','Othercontribs','Otherlanguages','Others','Pagemovedsub','Pagemovedtext','Pagetitle','Passwordremindertext','Passwordremindertitle','Passwordsent','Passwordtooshort','Perfcached','Perfdisabled','Perfdisabledsub','Personaltools','Popularpages','Portal','Portal-url','Postcomment','Poweredby','Powersearch','Powersearchtext','Preferences','Prefs-help-email','Prefs-help-email-enotif','Prefs-help-realname','Prefs-misc','Prefs-personal','Prefs-rc','Prefslogintext','Prefsnologin','Prefsnologintext','Prefsreset','Preview','Previewconflict','Previewnote','Previousdiff','Previousrevision','Prevn','Print','Printableversion','Printsubtitle','Protect','Protectcomment','Protectedarticle','Protectedpage','Protectedpagewarning','Protectedtext','Protectlogpage','Protectlogtext','Protectmoveonly','Protectpage','Protectsub','Protectthispage','Proxyblocker','Proxyblockreason','Proxyblocksuccess','Pubmedurl','Qbbrowse','Qbedit','Qbfind','Qbmyoptions','Qbpageinfo','Qbpageoptions','Qbsettings','Qbspecialpages','Randompage','Randompage-url','Range_block_disabled','Rchide','Rclinks','Rclistfrom','Rcliu','Rcloaderr','Rclsub','Rcnote','Rcnotefrom','Rcpatroldisabled','Rcpatroldisabledtext','Readonly','Readonly_lag','Readonlytext','Readonlywarning','Recentchanges','Recentchanges-url','Recentchangesall','Recentchangescount','Recentchangeslinked','Recentchangestext','Redirectedfrom','Remembermypassword','Removechecked','Removedwatch','Removedwatchtext','Removingchecked','Renamegrouplogentry','Resetprefs','Restorelink','Restorelink1','Restrictedpheading','Resultsperpage','Retrievedfrom','Returnto','Retypenew','Reupload','Reuploaddesc','Reverted','Revertimg','Revertmove','Revertpage','Revhistory','Revisionasof','Revisionasofwithlink','Revnotfound','Revnotfoundtext','Rfcurl','Rights','Rightslogtext','Rollback','Rollback_short','Rollbackfailed','Rollbacklink','Rows','Saturday','Savearticle','Savedprefs','Savefile','Savegroup','Saveprefs','Saveusergroups','Scarytranscludedisabled','Scarytranscludefailed','Scarytranscludetoolong','Search','Searchdisabled','Searchfulltext','Searchquery','Searchresults','Searchresultshead','Searchresulttext','Sectionlink','Selectnewerversionfordiff','Selectolderversionfordiff','Selflinks','Selflinkstext','Selfmove','Sep','September','Servertime','Sessionfailure','Set_rights_fail','Set_user_rights','Setbureaucratflag','Setstewardflag','Shareddescriptionfollows','Sharedupload','Shareduploadwiki','Shortpages','Show','Showbigimage','Showdiff','Showhideminor','Showingresults','Showingresultsnum','Showlast','Showpreview','Showtoc','Sidebar','Sig_tip','Sitenotice','Sitestats','Sitestatstext','Sitesubtitle','Sitesupport','Sitesupport-url','Sitetitle','Siteuser','Siteusers','Skin','Skinpreview','Sorbs','Sorbs_create_account_reason','Sorbsreason','Sourcefilename','Spamprotectionmatch','Spamprotectiontext','Spamprotectiontitle','Speciallogtitlelabel','Specialloguserlabel','Specialpage','Specialpages','Spheading','Sqlhidden','Statistics','Storedversion','Stubthreshold','Subcategories','Subcategorycount','Subcategorycount1','Subject','Subjectpage','Successfulupload','Summary','Sunday','Sysoptext','Sysoptitle','Tableform','Tagline','Talk','Talkexists','Talkpage','Talkpagemoved','Talkpagenotmoved','Talkpagetext','Templatesused','Textboxsize','Textmatches','Thisisdeleted','Thumbnail-more','Thumbsize','Thursday','Timezonelegend','Timezoneoffset','Timezonetext','Titlematches','Toc','Tog-editondblclick','Tog-editsection','Tog-editsectiononrightclick','Tog-editwidth','Tog-enotifminoredits','Tog-enotifrevealaddr','Tog-enotifusertalkpages','Tog-enotifwatchlistpages','Tog-externaldiff','Tog-externaleditor','Tog-fancysig','Tog-hideminor','Tog-highlightbroken','Tog-justify','Tog-minordefault','Tog-nocache','Tog-numberheadings','Tog-previewonfirst','Tog-previewontop','Tog-rememberpassword','Tog-shownumberswatching','Tog-showtoc','Tog-showtoolbar','Tog-underline','Tog-usenewrc','Tog-watchdefault','Toolbox','Tooltip-compareselectedversions','Tooltip-diff','Tooltip-minoredit','Tooltip-preview','Tooltip-save','Tooltip-search','Tooltip-watch','Trackback','Trackbackbox','Trackbackdeleteok','Trackbackexcerpt','Trackbacklink','Trackbackremove','Tryexact','Tuesday','Uclinks','Ucnote','Uctop','Unblockip','Unblockiptext','Unblocklink','Unblocklogentry','Uncategorizedcategories','Uncategorizedpages','Undelete','Undelete_short','Undelete_short1','Undeletearticle','Undeletebtn','Undeletedarticle','Undeletedrevisions','Undeletedtext','Undeletehistory','Undeletepage','Undeletepagetext','Undeleterevision','Undeleterevisions','Underline-always','Underline-default','Underline-never','Unexpected','Unit-pixel','Unlockbtn','Unlockconfirm','Unlockdb','Unlockdbsuccesssub','Unlockdbsuccesstext','Unlockdbtext','Unprotect','Unprotectcomment','Unprotectedarticle','Unprotectsub','Unprotectthispage','Unusedcategories','Unusedcategoriestext','Unusedimages','Unusedimagestext','Unwatch','Unwatchthispage','Updated','Upload','Upload_directory_read_only','Uploadbtn','Uploadcorrupt','Uploaddisabled','Uploadedfiles','Uploadedimage','Uploaderror','Uploadlink','Uploadlog','Uploadlogpage','Uploadlogpagetext','Uploadnewversion','Uploadnologin','Uploadnologintext','Uploadscripted','Uploadtext','Uploadvirus','Uploadwarning','Usenewcategorypage','User_rights_set','Usercssjsyoucanpreview','Usercsspreview','Userexists','Userjspreview','Userlogin','Userlogout','Usermailererror','Userpage','Userrights','Userrights-editusergroup','Userrights-groupsavailable','Userrights-groupshelp','Userrights-groupsmember','Userrights-logcomment','Userrights-lookup-user','Userrights-user-editname','Userstats','Userstatstext','Val_add','Val_article_lists','Val_clear_old','Val_del','Val_details_th','Val_details_th_user','Val_form_note','Val_iamsure','Val_list_header','Val_merge_old','Val_my_stats_title','Val_no','Val_no_anon_validation','Val_noop','Val_of','Val_page_validation_statistics','Val_percent','Val_percent_single','Val_rev_for','Val_rev_stats','Val_revision','Val_revision_changes_ok','Val_revision_number','Val_revision_of','Val_revision_stats_link','Val_show_my_ratings','Val_stat_link_text','Val_tab','Val_table_header','Val_this_is_current_version','Val_time','Val_topic_desc_page','Val_total','Val_user_stats_title','Val_user_validations','Val_validate_article_namespace_only','Val_validate_version','Val_validated','Val_validation_of','Val_version','Val_version_of','Val_view_version','Val_votepage_intro','Val_warning','Val_yes','Validate','Variantname-zh','Variantname-zh-cn','Variantname-zh-hk','Variantname-zh-sg','Variantname-zh-tw','Version','Versionrequired','Versionrequiredtext','Viewcount','Viewprevnext','Views','Viewsource','Viewtalkpage','Wantedpages','Watch','Watchdetails','Watcheditlist','Watchlist','Watchlistall1','Watchlistall2','Watchlistcontains','Watchlistsub','Watchmethod-list','Watchmethod-recent','Watchnochange','Watchnologin','Watchnologintext','Watchthis','Watchthispage','Wednesday','Welcomecreation','Whatlinkshere','Whitelistacctext','Whitelistacctitle','Whitelistedittext','Whitelistedittitle','Whitelistreadtext','Whitelistreadtitle','Wikipediapage','Wlheader-enotif','Wlheader-showupdated','Wlhide','Wlhideshowown','Wlnote','Wlsaved','Wlshow','Wlshowlast','Wrong_wfQuery_params','Wrongpassword','Yourdiff','Yourdomainname','Youremail','Yourlanguage','Yourname','Yournick','Yourpassword','Yourpasswordagain','Yourrealname','Yourtext','Yourvariant')
      Function: 
      Error: 1142 select command denied to user 'wikiuser'@'localhost' for table
'tf_page' (localhost)

      Backtrace:
      GlobalFunctions.php line 451 calls wfbacktrace()
      Database.php line 397 calls wfdebugdiebacktrace()
      Database.php line 347 calls databasemysql::reportqueryerror()
      InitialiseMessages.inc line 140 calls databasemysql::query()
      InitialiseMessages.inc line 72 calls initialisemessagesreal()
      updaters.inc line 670 calls initialisemessages()
      index.php line 606 calls do_all_updates()

All of a sudden with no reason, my user has no access to do a select on a
table?? What give?

I went into mysql as user root from the cpommand line and ran
   GRANT ALL PRIVILEGES ON my_wikidb.* to wikiuser@localhost
   IDENTIFIED BY 'wikipassword' WITH GRANT OPTION;

I then re-ran the MediaWiki installation, setting the root password to '-'
and got to the end successfully
Initialising "MediaWiki" namespace...
Clearing message cache...Done.

# Finished update checks.

Creating LocalSettings.php...

Installation successful! Move the config/LocalSettings.php file into the parent
directory, then follow this link to your wiki.

I don't mind having to do this, but I think if the installer is supposed to be
able to do everything for me it ought to work.

Did you specify superuser information at the bottom of the installation form? It
defaults to assuming the user has the permissions granted if you don't.

I've made this all very clear in the report.
Yes I specify the root password.
Yes the user has privileges (until they are mysteriously lost halfway through
the installation).
Some tables are cfreated. Others are not (and there is an error).

Again, if this were simple I wouldn't be filing the repoort. It's not simple.
It's mysterious, occasional, and different every time.

I believe that this is a problem that only happens on new installations of
MediaWiki on Mac OS X 10.4.X using the preinstalled mysql. 

>Error: 1142 select command denied to user 'wikiuser'@'localhost' for table

The problem is that the wikiuser you define tries to connect to localhost, which
is not the default hostname in 10.4.
The solution is to look in the user table in the mysql database, and change the
host_name for wikiuser to <computer_name>.local
where computer name is the name of your host.  This fixed the problem for me. I
have no idea why Apple changed this.

Odd - OSX 10.4.7 (at least) seems to know about localhost:

  %  ping localhost
  PING localhost (127.0.0.1): 56 data bytes
  64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.093 ms
  64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.073 ms

This installation of MediaWiki is installed on FreeBSD 4.7.

It is not installed on Mac OS X.

localhost is well understood on FreeBSD and none of my otherMySQL databases have
any problems.

Apparebtly the bug reporting software made inappropriate guesses based on my Web
browser configuration and I did not see that.

(In reply to comment #13)
> Odd - OSX 10.4.7 (at least) seems to know about localhost:

While this is true, it's unrelated because comment #12 does not apply to this
installation.

How much of this is still happening? I recall (how could I forget?) the rather
ridiculous security bug I introduced some time before 1.5.6 (messed about with
MySQL's root password) which *might* explain the permissions funkiness here. If
other problems are still occurring with the latest version, it might be an idea
to relist those, or close this bug in favour of new ones separating any
reproducable issues.

Going to assume that the fixes to the installer a couple versions back solved this,
closing WORKSFORME.