LAMP (SoftInstall)

LAMP

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>

Php

Install

$ sudo apt-get install php
$ sudo apt-get install php-gd