Mediawiki/Installing
From r00tedvw.com wiki
(Difference between revisions)
Line 27: | Line 27: | ||
Create mysql wiki user | Create mysql wiki user | ||
~$ mysql> CREATE USER 'wiki'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED'; | ~$ mysql> CREATE USER 'wiki'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED'; | ||
+ | ~$ mysql> exit | ||
+ | login as new user to verify account works | ||
+ | ~$ mysql -u wiki -p | ||
+ | ~$ mysql> exit | ||
+ | create DB | ||
+ | ~$ mysql -u root -p | ||
+ | ~$ mysql> CREATE DATABASE sewikidatabase; | ||
+ | verify DB creation | ||
+ | ~$ mysql> SHOW DATABASES; | ||
+ | assign rights to wiki user for new database created | ||
+ | ~$ mysql> GRANT ALL PRIVILEGES ON sewikidatabase.* TO 'wiki'@'localhost' IDENTIFIED BY 'wikiuserpassword' WITH GRANT OPTION; | ||
+ | ~$ mysql> exit | ||
+ | verify permissions have been granted | ||
+ | ~$ mysql -u wiki -p | ||
+ | ~$ mysql> SHOW GRANTS; | ||
+ | +---------------------------------------------------------------------------------------------------------------+ | ||
+ | | Grants for wiki@localhost | | ||
+ | +---------------------------------------------------------------------------------------------------------------+ | ||
+ | | GRANT USAGE ON *.* TO 'wiki'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' | | ||
+ | +---------------------------------------------------------------------------------------------------------------+ | ||
+ | 1 row in set (0.00 sec) |
Revision as of 12:57, 28 April 2014
install apache2
find the package name and install
~$ sudo yum search apache Loaded plugins: security ... httpd.x86_64 : Apache HTTP Server ~$ sudo yum install httpd.x86_64
install php & mysql
~$ sudo yum install php php-mysql php-gd mysql-server php-xml mysql
setup mysql
make sure mysql is started
~$ sudo service mysqld status or ~$ sudo service mysqld start
setup the basics
~$ sudo mysql_secure_installation Set root password? [Y/n] y Remove anonymous users? [Y/n] y Disallow root login remotely? [Y/n] y Remove test database and access to it? [Y/n] y Reload privilege tables now? [Y/n] y
login to db
~$ mysql -u root -p
Create mysql wiki user
~$ mysql> CREATE USER 'wiki'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED'; ~$ mysql> exit
login as new user to verify account works
~$ mysql -u wiki -p ~$ mysql> exit
create DB
~$ mysql -u root -p ~$ mysql> CREATE DATABASE sewikidatabase;
verify DB creation
~$ mysql> SHOW DATABASES;
assign rights to wiki user for new database created
~$ mysql> GRANT ALL PRIVILEGES ON sewikidatabase.* TO 'wiki'@'localhost' IDENTIFIED BY 'wikiuserpassword' WITH GRANT OPTION; ~$ mysql> exit
verify permissions have been granted
~$ mysql -u wiki -p ~$ mysql> SHOW GRANTS; +---------------------------------------------------------------------------------------------------------------+ | Grants for wiki@localhost | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'wiki'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' | +---------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)