v1.0+
Status: | effective |
Progress: | 100% |
Version: | 1.0+ |
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]
- Help page on configuration parameter
$smwgDefaultStore
Sets the storage backend to be used for the semantic data