Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-06 Thread Platonides
Sullivan, James (NIH/CIT) [C] wrote: > The question I have is whether this will lead to problems in the future, such > as upgrade to version 1.17.0, > where the database user may be assumed to have ALL privileges. Depends on what is needed on upgrade to that future version. It's just a safeguard

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-06 Thread Sullivan, James (NIH/CIT) [C]
-Original Message- From: Platonides [mailto:platoni...@gmail.com] Sent: Thursday, August 05, 2010 7:25 PM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege That's what bug 20634. In some cases there were proble

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Platonides
Sullivan, James (NIH/CIT) [C] wrote: > Yes, I think this is the problem, that my superuser is missing a privilege or > two. Since the error is trying to add "ALL" privilege to the database_user, > you would pretty much have to use the mysql root account to do the > installation, which is likely

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Sullivan, James (NIH/CIT) [C]
From: Benjamin Lees [mailto:emufarm...@gmail.com] Sent: Thursday, August 05, 2010 2:16 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege >Right. Users created through the installer pre-1.16 only had >DELETE,

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Benjamin Lees
On Thu, Aug 5, 2010 at 11:32 AM, Sullivan, James (NIH/CIT) [C] wrote: > That bug (20634)is about having privilege to create tables. During my 1.16.0 > installation tables were successfully created. It was granting the wiki > database user "ALL" privilege that was the problem because my databas

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Lewis Cawte
o: MediaWiki announcements and site admin list > Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user > privilege > > On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] > wrote: > >> Have the privilege requirements for the database user

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Sullivan, James (NIH/CIT) [C]
version 1.16.0 will run fine, so why the change for new installations? -Jim -Original Message- From: Benjamin Lees [mailto:emufarm...@gmail.com] Sent: Wednesday, August 04, 2010 5:39 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] installation issue with 1.16

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-05 Thread Gabriel Filion
On 10-08-04 04:40 PM, Sullivan, James (NIH/CIT) [C] wrote: > Query "GRANT ALL PRIVILEGES ON 'database_name'.* TO 'database_user'@'%' > IDENTIFIED BY 'database_password' " failed with error code "Access denied for > user mysql_u...@mysql_host to database 'database_name' (database_server)". > To

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread Platonides
David Gerard wrote: > IME, the user rights for MediaWiki frequently need bludgeoning. I > routinely end up doing (something like): > > GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost'; > GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%'; > > - and it seems I need both. You need the

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread David Gerard
On 4 August 2010 23:01, Platonides wrote: > Benjamin Lees wrote: >> On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] >> wrote: >>> Have the privilege requirements for the database user privileges changed >>> from 1.15 to 1.16 for installing mediawiki?  I did not see any mention of

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread Platonides
Benjamin Lees wrote: > On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] > wrote: >> Have the privilege requirements for the database user privileges changed >> from 1.15 to 1.16 for installing mediawiki? I did not see any mention of >> this in the release notes. > > Yes, it's in t

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread Benjamin Lees
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C] wrote: > Have the privilege requirements for the database user privileges changed from > 1.15 to 1.16 for installing mediawiki?  I did not see any mention of this in > the release notes. Yes, it's in the release notes (though it's bu

Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread Lewis Cawte
On 04/08/10 21:40, Sullivan, James (NIH/CIT) [C] wrote: > Hi all, > > I have been installing many mediawiki wikis over the past few years using a > remote mysql server. I do not use the mysql "root" account but instead use > another user, which has had the proper privileges to install the databa

[Mediawiki-l] installation issue with 1.16.0 - mysql user privilege

2010-08-04 Thread Sullivan, James (NIH/CIT) [C]
Hi all, I have been installing many mediawiki wikis over the past few years using a remote mysql server. I do not use the mysql "root" account but instead use another user, which has had the proper privileges to install the database, until version 1.16.0. When I install the mediawiki version