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


Details[edit | edit source]

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  • 日本語 • русский