Manual:$wgDBsqluser

From MediaWiki.org
Jump to: navigation, search
Sysop SQL queries: $wgDBsqluser
The SQL user used for queries.
Introduced in version: pre 1.1.0
Removed in version: 1.5.0
Allowed values: (string)
Default value: 'sqluser'

Other settings: Alphabetical | By Function


[edit] Details

The SQL user used for read-only queries in the (no longer existing) Special:Asksql.

Attention niels epting.svg WARNING: THIS IS VERY INSECURE. If you want to allow semipublic read-only SQL access for your sysops, you should define a MySQL user with limited privileges. Review the MySQL documentation at http://www.mysql.com/doc/en/GRANT.html on how permissions can be granted in the database subsystem.

The MySQL user shouldn't have too many rights over the database, restrict it to SELECT only on 'cur' table for example.

Language: English  • 日本語 • русский
Personal tools
Namespaces

Variants
Actions
Navigation
Support
Download
Development
Communication
Print/export
Toolbox