I have these 2 in adminsettings.php: $wgDBadminuser $wgDBadminpassword
And in localsettings.php: $wgDBuser $wgDBpassword
These both have the same username and password. Not sure what else to change. When I changed the password (just for kicks), it immediately gave me a bad username password error. With them correct, the update.php script runs with no error until the error I mentioned below. To me, that means it is initially accepting the username and password.
Why is it failing further in the update?
Thanks again, Dave
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Rob Church Sent: Monday, January 08, 2007 2:46 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Error Updating to 1.8.2
On 08/01/07, David_S_Green@dell.com David_S_Green@dell.com wrote:
I have the correct username and password in that file. Do I need additional info?
*Which* username and password?
Most wikis will need MediaWiki set up to operate based on two sets of MySQL credentials; the normal use user and the maintenance user.
The first requires INSERT, SELECT, UPDATE and DELETE permissions on the database; it's specified using $wgDBuser and $wgDBpassword in LocalSettings.php, and MediaWiki uses it for non-maintenance tasks (although some maintenance scripts which don't do anything fancy will also use it).
The second is set up in AdminSettings.php and *additionally* requires CREATE, ALTER and DROP permissions on the database (and possibly INDEX).
(The other credentials come into play in replication scenarios, external storage, common repositories and all manner of other goodies.)
Rob Church
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l