Difference between revisions of "mediawiki installation - database and file permissions"
From thelinuxwiki
(Pushed from Themanclub.) |
(Pushed from Themanclub.) |
||
Line 19: | Line 19: | ||
Query OK, 0 rows affected (0.01 sec) | Query OK, 0 rows affected (0.01 sec) | ||
− | mysql> GRANT ALL ON mediawiki_db.* TO ' | + | mysql> GRANT ALL ON mediawiki_db.* TO 'username'@'localhost' IDENTIFIED BY 'password'; |
Query OK, 0 rows affected (0.00 sec) | Query OK, 0 rows affected (0.00 sec) | ||
Latest revision as of 16:17, 10 July 2013
preparing a database via CLI
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | +--------------------+ 2 rows in set (0.00 sec)
mysql> create database mediawiki_db; Query OK, 1 row affected (0.02 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON database_name.* TO 'username'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL ON mediawiki_db.* TO 'username'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec)
mysql> quit Bye
ownership and permissons
# chown -R apache:apache <PATH_TO_MEDIAWIKI_DIRECTORY>
# chmod 700 <path to LocalSettings.php> *** not sure of permissions