Database privileges

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

User

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

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

• Help page on configuration parameter $smwgDefaultStoreSets the storage backend to be used for the semantic data