LAMP (SoftInstall)

LAMP

Date time

# ln -sf /usr/share/zoneinfo/ROK /etc/localtime
# date

MySQL

Install

$ sudo apt-get update
$ sudo apt-get install mysql-server
$ sudo systemctl  start mysql
$ sudo systemctl enable mysql

To set initial password

$ mysql_secure_installation

Problem in root password

Disable password checking temporally. by adding a line at /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
skip-grant-tables

Stop and restart mysql

$ sudo systemctl  stop mysql
$ sudo systemctl  start mysql

Change using no password mode.

$ mysql -u -p
mysql> user mysql;
mysql> update user set plugin="mysql_native_password" where User='root';
mysql> update user set authentication_string=PASSWORD('newpassword') where User='root';
mysql> flush privileges;
mysql> quit

Restart mysql after deleting "skip-grant-table"

$ sudo systemctl  stop mysql
$ sudo systemctl  start mysql

Check if working well.

$ mysql -u root -p
Enter password: xxxx
mysql> use user;
mysql> select * from user where User='root';

Apache2

Install

$ sudo apt-get install apache2 apache2-utils

$ sudo systemctl enable apache2
$ sudo systemctl start apache2

Missing file

404 Not found를 처리하기 위해 /etc/apache2/apache.conf를 수정

<Directory / >
Overrride FileInfo
ErrorDocument 404 /error.html
</Directory>

SSL

Lets Encrypt SSL install; (for ubuntu)

$ sudo add-apt-repository ppa:certbot/certbot
$ sudo apt install python-certbot-apache

Setup SSL Certificate; Modify /etc/apache2/sites-available/000-default.conf</conf>. Change server name properly.

ServerName atomic.snu.ac.kr

Check configuration

$ sudo apache2ctl configtest

Obtain an SSL certicate

$ sudo certbot --apache -d atomic.snu.ac.kr

Verify SSL auto renewal.

$ sudo certbot renew --dry-run

Php

Install

$ sudo apt-get install php
$ sudo apt-get install php-gd
$ sudo apt-get install libapache2-mod-php php-mysql