Manual:$wgDBsqluser/pl

From Linux Web Expert

Revision as of 00:42, 6 December 2023 by imported>FuzzyBot (Updating to match new version of source page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

<translate> Database settings</translate>: $wgDBsqluser
The SQL user used for queries.
<translate> Introduced in version:</translate>pre 1.1.0
<translate> Removed in version:</translate>1.5.0
<translate> Allowed values:</translate>(łańcuch)
<translate> Default value:</translate>'sqluser'

Szczegóły

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

File:OOjs UI icon notice-destructive.svg <translate> Warning:</translate> 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://dev.mysql.com/doc/refman/5.7/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.