View source for Manual:Maintenance scripts/Configuration

<languages />
__NOTOC__
{{Maintenance scripts}}


<translate><!--T:1--> The <tvar name=1><code>{{ll|Manual:$wgDBadminuser|$wgDBadminuser}}</code></tvar> and <tvar name=2><code>{{ll|Manual:$wgDBadminpassword|$wgDBadminpassword}}</code></tvar> configuration variables must be set in order to run maintenance scripts that need to alter the structure of the database (like <tvar name=3>{{ll|Manual:update.php}}</tvar>) if the user configured in <tvar name=4>{{ll|Manual:$wgDBuser}}</tvar> doesn't have enough permissions.</translate>
<translate><!--T:2--> Alternatively, you can pass the <tvar name=1><kbd>--dbuser</kbd></tvar> and <tvar name=2><kbd>--dbpass</kbd></tvar> parameters to the script.</translate><!-- What about SQLite-backed installs? -->
<translate><!--T:3--> The values for these variables differ based on the database engine that is being used to power your installation of MediaWiki.</translate>
<translate><!--T:4--> If not configured, it will use the user configured in <tvar name=1>{{ll|Manual:$wgDBuser}}</tvar>.</translate>

<translate>
===MySQL=== <!--T:14-->
</translate>
<translate><!--T:5--> Some of the maintenance scripts require database permissions that, for security reasons, the main MediaWiki database account should not have.</translate>
<translate><!--T:6--> A separate database account with 'superuser' privileges for just the MediaWiki database should be created (if it does not already exist.)</translate>
<translate><!--T:7--> If the database that you use for MediaWiki is called <tvar name=1><code>wikidb</code></tvar>, then the following SQL would create such a user who can exercise superuser privileges on localhost.:</translate>
{{-}}
<syntaxhighlight lang="sql" style="overflow:auto;">
GRANT ALL PRIVILEGES ON wikidb.* TO 'wikidbadmin'@'localhost' IDENTIFIED BY 'strong-password';
</syntaxhighlight>

<translate><!--T:8--> Once the account exists, the account name should be set in the <tvar name=1><code>{{ll|Manual:$wgDBadminuser|$wgDBadminuser}}</code></tvar> configuration variable.</translate>
<translate><!--T:9--> Like other configuration variables, <tvar name=1>{{phpi|$wgDBadminuser}}</tvar> should be set in <tvar name=2>{{ll|Manual:LocalSettings.php|LocalSettings.php}}</tvar>.</translate>
<translate><!--T:10--> A password for <tvar name=1>{{phpi|$wgDBadminuser}}</tvar> must be set in the <tvar name=3><code>{{ll|Manual:$wgDBadminpassword|$wgDBadminpassword}}</code></tvar> configuration variable.</translate>

<translate>
===PostgreSQL=== <!--T:15-->
</translate>
<translate><!--T:11--> PostgreSQL uses a different security model than MySQL and the same PostgreSQL server account used for day-to-day operation of the MediaWiki installation must also be used for running the maintenance scripts.</translate>
<translate><!--T:12--> This is necessary to ensure that the owner for new tables created by the maintenance scripts is set correctly.</translate>
<translate><!--T:13--> You don't need to set <tvar name=1>{{phpi|$wgDBadminuser}}</tvar> or <tvar name=2>{{phpi|$wgDBadminpassword}}</tvar> at all.</translate>

[[Category:Maintenance scripts{{#translation:}}]]