How to Install WordPress with Mariadb(or MySQL) on Ubuntu-20.04

##############################################################

Environment

  Device :  Odroid-HC2

  OS : Ubuntu-20.04

  IP : 192.168.101.100

  Pre Insall App : Mariadb(or MySQL), NGINX, PHP

##############################################################

1. Install WordPress

$ sudo apt install wordpress -y

2. Generate database for WordPress

##############################################################
WordPress 
  SQL database : wordpress
  SQL userid : wordpress
  SQL password : test@test
##############################################################
  
$ sudo mysql -u root
> create database wordpress;
> grant all on wordpress.* to wordpress@localhost identified by 'test@test';
> flush privileges;
> quit;

3. Setup WordPress

$ sudo ln -s /usr/share/wordpress /var/www/html/wp

$ sudo ls /var/www/html/ -l

$ sudo chown -R www-data:www-data /var/www/html/wp

$ sudo chown -R www-data:www-data /var/www/html/wp/

$ sudo ls /var/www/html/ -l

$ sudo ls /var/www/html/wp/ -l

$ sudo cp /var/www/html/wp/wp-config-sample.php /var/www/html/wp/wp-config.php

$ sudo nano /var/www/html/wp/wp-config.php

Change Configuration

define( 'DB_NAME', 'database_name_here' );
=>
define( 'DB_NAME', 'wordpress' );
define( 'DB_USER', 'username_here' );
=>
define( 'DB_USER', 'wordpress' );
define( 'DB_PASSWORD', 'password_here' );
=>
define( 'DB_PASSWORD', 'test@test' );

Insert Configuration

/** Enable Direct Update **/
define('FS_METHOD', 'direct');

$ sudo systemctl restart nginx

4. Connect Web

test@test.com

How to Install NGINX on Ubuntu-20.04

How to Install NGINX on Ubuntu-20.04

---

    Environment
      Device : Odroid-HC2
      OS : Ubuntu-20.04
      Host : test (192.168.101.100)

---

1. Install NGINX 

1. Install NGINX

1) Install NGINX

$ sudo apt install nginx -y
$ nginx -v

Connect http://192.168.101.210

2) Install PHP

$ sudo apt install php php-fpm php-mysql -y
$ sudo apt remove apache2 --purge -y
$ sudo rm -rf /etc/apache2
$ sudo netstat -an | grep php

3) Setup NGIX For PHP

$ sudo mv /etc/nginx/sites-available/default /etc/nginx/sites-available/default.orig
$ sudo rm /etc/nginx/sites-enabled/default
$ sudo netstat -an | grep php

check php socket

$ sudo nano /etc/nginx/sites-available/default

Insert Configuration

server{

        listen                  80;
        server_name             test.local;
       root /var/www/html;
       index index.html index.htm index.php index.nginx-debian.html;
       location / {
               try_files $uri $uri/ =404;
       }
       location ~ \.php$ {
              fastcgi_pass unix:/run/php/php7.4-fpm.sock;
              fastcgi_index index.php;
              fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
              include fastcgi_params;
       }
}

$ cd /etc/nginx/sites-enabled/
$ ls -l
$ sudo -i
# cd /etc/nginx/sites-enabled/
# ln -s /etc/nginx/sites-available/default
# ls -l
# exit

$ sudo nano /var/www/html/phpinfo.php

Insert Configuration

<?php
  phpinfo();
?>

Connect http://192.168.101.100/phpinfo.php

2. Install HTTPS service

1) Generate SSL Certification

Generate private key

$ sudo openssl genrsa -des3 -out server.key 2048

Generate CSR(Certification sinning Request)

$ sudo openssl req -new -days 365 -key server.key -out server.csr

Clear password of Private key

$ sudo cp server.key server.key.orig
$ sudo openssl rsa -in server.key.orig -out server.key

Create Certification

$ sudo openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

Verify Certification

$ ls -l server.*
$ sudo cat server.key | head -3
$ sudo cat server.crt | head -3

Copy Certification

$ sudo mkdir /etc/nginx/ssl
$ sudo cp ~/server.* /etc/nginx/ssl/

2) Setup NGINX For HTTPS

$ sudo nano /etc/nginx/sites-available/default

Insert Configuration

server{
        listen                  443;
        server_name             test.local;
       root /var/www/html;
       index index.html index.htm index.php index.nginx-debian.html;
        ssl                     on;
        ssl_certificate         /etc/nginx/ssl/server.crt;
        ssl_certificate_key     /etc/nginx/ssl/server.key;
        ssl_protocols           TLSv1 TLSv1.1 TLSv1.2;
       location / {
               try_files $uri $uri/ =404;
       }
       location ~ \.php$ {
              fastcgi_pass unix:/run/php/php7.4-fpm.sock;
              fastcgi_index index.php;
              fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
              include fastcgi_params;
       }
}

Connect https://192.168.101.100

Connect https://192.168.101.100/phpinfo.php