Extension:Asksql

MediaWiki extensions manual - list

Asksql Release status: stable
Implementation	Special page, Database
Description	Allows SQL queries through a special page in the wiki, without opening phpMyAdmin etc.
Author(s)	Brion Vibber
Last version	2008-01-31 (2008-01-31)
MediaWiki	1.12 and above
License	GPL
Download	Download snapshot (Git master) Git [?]: repo summary • tree • code changes SVN [?]: checkout-url • tree • code changes
Added rights asksql
Check usage (experimental)

Asksql extension allows you to do SQL queries through a special page in the wiki, without opening phpMyAdmin etc.

Warning: Dangerous if not configured properly!

Installation

1. Download the latest snapshot, extract the files, and place them under extensions/Asksql
2. Make sure you have ExtensionFunctions.php in your extensions/ folder
3. Add $wgGroupPermissions['bureaucrat']['asksql'] = true; to LocalSettings.php
4. Add require_once('extensions/Asksql/Asksql.php'); to LocalSettings.php
5. Go to Special:Asksql to test the extension out

This extension sets $wgAllowSysopQueries = true;, so keep that in mind. You must configure $wgDBsqluser and $wgDBsqlpassword in your LocalSettings.php though.

Settings

Note: On the individual pages for these settings, it says deprecated in 1.5, since this extension was split from core mediawiki in that version. If you've installed the extension, these settings apply regardless

• $wgAllowSysopQueries Set to allow sysop queries.
• $wgDBsqlpassword The password for $wgDBsqluser.
• $wgDBsqluser The SQL user used for queries.