MariaDB/MediaWiki: Difference between revisions
From Bibliotheca Anonoma
Antonizoon (talk | contribs) No edit summary |
Antonizoon (talk | contribs) No edit summary |
||
Line 23: | Line 23: | ||
{{hc|sudo mysql|<nowiki> | {{hc|sudo mysql|<nowiki> | ||
CREATE DATABASE wikidb; | CREATE DATABASE wikidb; | ||
GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY 'password'; | GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY 'password'; | ||
FLUSH PRIVILEGES; | |||
</nowiki>}} | </nowiki>}} |
Latest revision as of 04:32, 16 April 2017
You must install either MySQL or MariaDB on your Linux distribution. MariaDB is strongly preferred, but otherwise they are both compatible as they are forks.
- Repository Generator: https://downloads.mariadb.org/mariadb/repositories/
Then, follow these instructions to set up the database securely.
https://mariadb.com/resources/blog/installing-mariadb-10-centos-7-rhel-7
Now, start the MySQL/MariaDB server for the first time.
sudo systemctl start mysql
Once the server works, enable it to start at every boot.
sudo systemctl enable mysql
Finally, create a database and user for MediaWiki to use. Remember this database name, username and password, since you will need it once you configure MediaWiki. Change the password placeholder with your real password.
sudo mysql
CREATE DATABASE wikidb; GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;