Extension:Asksql

From MediaWiki.org

Jump to: navigation, search
Manual on MediaWiki Extensions
List of MediaWiki Extensions
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
Version 2008-01-31 (2008-01-31)
MediaWiki 1.12 and above
Download SVN

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

Warning Warning: Dangerous if not configured properly!

[edit] Installation

  1. Download the files from SVN and place them under extensions/Asksql
  2. Make sure you have ExtensionFunctions.php in your extensions/ folder
  3. Add $wgGroupPermissions['sysop' ]['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.

Personal tools