Database privileges

From semantic-mediawiki.org

When using a SQL database (MySQL or MariaDB) the following minimum database privileges need to be set for the respective database users:

User[edit]

As defined with configuration parameter $wgDBuser (MediaWiki.org):

SQL privileges
  • DELETE
  • INSERT
  • SELECT
  • UPDATE
  • CREATE TEMPORARY TABLES (only needed if you are using Semantic MediaWiki)
  • REPLICATION CLIENT (only needed if you are using replication)
Example MySQL command
GRANT DELETE, INSERT, SELECT, UPDATE, CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost';

Admin user[edit]

As defined with configuration parameter $wgDBadminuser (MediaWiki.org):

SQL privileges
  • All privileges as mentioned above plus the following:
  • ALTER
  • CREATE
  • DROP
  • INDEX
  • LOCK TABLES
Example SQL command
GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, LOCK TABLES, SELECT, UPDATE, CREATE TEMPORARY TABLES ON database.* TO 'adminuser'@'localhost';

See also[edit]