MySQL Database Permissions

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL Database Permissions

Donald Schmitt
What permissions are needed by Wiki to use the database?
Do all permissions need to be provided?
These are the choices I have:
Select
Insert
Update
Delete
Create
Drop
Index
Alter

Thanks.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MySQL Database Permissions

Rob Church
In normal usage, the database user needs SELECT, INSERT, UPDATE and
DELETE permissions on the database.


Rob Church

On 24/03/06, Donald Schmitt <[hidden email]> wrote:

> What permissions are needed by Wiki to use the database?
> Do all permissions need to be provided?
> These are the choices I have:
> Select
> Insert
> Update
> Delete
> Create
> Drop
> Index
> Alter
>
> Thanks.
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MySQL Database Permissions

Rick DeNatale
On 3/24/06, Rob Church <[hidden email]> wrote:
> In normal usage, the database user needs SELECT, INSERT, UPDATE and
> DELETE permissions on the database.

And when you upgrade to a new version which has a new database format
the installation code will likely need the others.

--
Rick DeNatale

Visit the Project Mercury Wiki Site
http://www.mercuryspacecraft.com/
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MySQL Database Permissions

Rob Church
That's handled with AdminSettings.php, pointing $wgDBadminuser etc. to
a user with appropriate permissions on the database to do that.


Rob Church

On 24/03/06, Rick DeNatale <[hidden email]> wrote:

> On 3/24/06, Rob Church <[hidden email]> wrote:
> > In normal usage, the database user needs SELECT, INSERT, UPDATE and
> > DELETE permissions on the database.
>
> And when you upgrade to a new version which has a new database format
> the installation code will likely need the others.
>
> --
> Rick DeNatale
>
> Visit the Project Mercury Wiki Site
> http://www.mercuryspacecraft.com/
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l