2022-02-27 - Guide LAMP + Wordpress

**********************************************************
PART 1

# sed -E -i -e 's/main/main contrib/' /etc/apt/sources.list ;
apt-get update && \
    apt-get upgrade -y && \
    apt-get install -y \
    apt-utils \
    git \
    wget \
    unzip \
    curl \
    nano \
    net-tools \
    nmap \
    traceroute \
    libaio1 \
    apache2 \
    libapache2-mod-php \
    php-pear \
    php \
    php-dev \
    php-curl \
    php-gd \
    php-imap \
    php-json \
    php-mysql \
    php-mbstring \
    php-zip \
    php-cli\
	mariadb-server;

echo 'ServerName localhost' >> /etc/apache2/apache2.conf ;
echo "Asia/Kuala_Lumpur" > /etc/timezone;

sed -E -i -e 's/memory_limit = 128M/memory_limit = 2G/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/upload_max_filesize = 2M/upload_max_filesize = 2G/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/post_max_size = 8M/post_max_size = 2G/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/max_execution_time = 30/max_execution_time = 300/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/max_execution_time = 60/max_execution_time = 600/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/;date.timezone =/date.timezone = "Asia\/Kuala_Lumpur"/' /etc/php/7.4/apache2/php.ini ;
sed -E -i -e 's/AllowOverride None/AllowOverride All/g' /etc/apache2/apache2.conf ;
sed -E -i -e 's/DocumentRoot \/var\/www\/html/DocumentRoot \/var\/www\/html\n        Alias \/api \/var\/www\/api\/public\n        Alias \/upload \/var\/www\/upload/' /etc/apache2/sites-available/000-default.conf ;
apt-get clean;

/usr/sbin/a2enmod rewrite headers ssl proxy proxy_http proxy_html && systemctl restart apache2 ;
systemctl reboot


**********************************************************
PART 2

# cd /var/www/html;
curl -O https://wordpress.org/latest.tar.gz;
tar xzvf latest.tar.gz;
chown -R www-data:www-data wordpress

**********************************************************
PART 3
# mv wordpress lkppk -v

**********************************************************
PART 4

# mysql_secure_installation

# mysql -u root -p
MariaDB > create database faleedb;
MariaDB > grant all privileges on faleedb.* to 'falee'@'localhost' identified by '112233';

**********************************************************
PART 5
open browser and Open

localhost/lkppk