|WARNING: The code or configuration described here poses a major security risk.
Site administrators: You are advised against using it until this security issue is resolved.
Problem: Vulnerable to SQL injection attacks, because it passes user input directly into SQL commands. This may lead to user accounts being hijacked, wiki content being compromised, private data being leaked, malware being injected, and the entire wiki content being erased, among other things.
Solution: make proper use of MediaWiki's database class instead of concatenating raw sql
Release status: stable
|Implementation||Special page, Database|
|Description||Allows SQL queries through a special page in the wiki, without opening phpMyAdmin etc.|
|Last version||2008-01-31 (2008-01-31)|
|MediaWiki||1.12 and above|
|Check usage and version matrix|
Asksql extension allows you to do SQL queries through Special:Asksql in the wiki, without opening phpMyAdmin etc.
Warning: Dangerous if not configured properly!
- Download and extract the files in a directory called "
Asksql" in your extensions/ folder.
- Add the following code to your LocalSettings.php (at the bottom)
require_once( "$IP/extensions/Asksql/Asksql.php" ); $wgGroupPermissions['bureaucrat']['asksql'] = true;
- Done – Navigate to Special:Version on your wiki to verify that the extension is successfully installed.