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

---

    Environment
      Device :  Odroid-HC2
      OS : Ubuntu-20.04
      HostName : test
      IP : 192.168.101.100
      Pre Insall App : Mairadb(or MySQL), NGINX, PHP

---

1. Install wordpress

$ sudo apt install php-curl php-gd php-mbstring php-xml php-xmlrpc php-soap php-intl php-zip php-net-ldap2 php-net-ldap3 php-net-idna2 -y
$ wget https://wordpress.org/latest.zip
$ unzip latest.zip

2. Generate database for wordpress

---

WordPress
   SQL database : wordpress
   SQL userid : wordpress
   SQL password : test@test

---

※ Change it to suit your environment

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

3. Copy WordPress

$ sudo cp -R wordpress /var/www/html/wp
$ sudo chown  -R www-data:www-data /var/www/html/wp
$ sudo ls /var/www/html/ -l

4. Generate WordPress Initial Setting

---

WordPress
  SQL database : wordpress
  SQL userid : wordpress
  SQL password : test@test

---

※ Change it to suit your environment

Connet to WordPress Web (http://192.168.101.100/wp)

Select your Language

Insert your Database Information

Insert your WordPress Infomation

Login your Account

Change your Theme

 How to Install Windows Fonts on Ubuntu

---

    Environment
      PC1 :
        Device : x64
        OS : Windows10
      PC2 :
        Device : Odroid-HC2(or XU4)
        OS : Ubuntu-20.04

---

1. Upload Windows Truetype Fonts to Ubuntu

Compressed Fonts Files on Windows

> mkdir TTF
> cd TTF
> copy C:\Windows\Fonts\*.ttf .\TTF\
> copy C:\Windows\Fonts\*.ttc .\TTF\

Compress TTF Folder

Copy Compressed File to Ubuntu

2. Install Truetype Fonts on Ubuntu

$ unzip TTF.zip
$ sudo cp -R TTF /usr/share/fonts/truetype/
$ sudo fc-cache -v -f

 How to Install XRDP

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

Environment

  Device :  Odroid-HC2(orXU4)

  OS : Ubuntu-20.04

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

1. Install XRDP

$ sudo install xrdp icewm -y
$ sudo install icewm -y
$ cp /etc/xrdp/startwm.sh /etc/xrdp/startwm.sh.orig
$ nano /etc/xrdp/startwm.sh

Change Configuration

test -x /etc/X11/Xsession && exec /etc/X11/Xsession
exec /bin/sh /etc/X11/Xsession

==>

#test -x /etc/X11/Xsession && exec /etc/X11/Xsession
#exec /bin/sh /etc/X11/Xsession
exec icewm-session

 How To Install Armbian(Ubuntu Focal:20.04) on Orange Pi R1

======================================

Environment

  Device : Orange Pi R1

  OS : Armbian(Ubuntu Focal:20.04)

  HostName : r1

  Ethernet Interfaces

   Main : enxc0742bfff848 :  192.168.101.101/24 (gw 192.168.101.1)

   Sub  : eth0 :  192.168.1.101/24

======================================

※ Odroid-C1 is not recommended.

  no HDMI output (serial console only)

  no USB hotplugging, power the board with USB device is needed

  eMMC not supported

  Limited SD card brand (known to work well)

※ Odroid-C2 is not recommended.

  It has USB troubles

  It can't Reset

1. Install Armbian(Ubuntu Focal:20.04) on Orange Pi R1

Download Armbian(Ubuntu Focal:20.04) Image from Armbian Website

Install Armbian(Ubuntu Focal:20.04) with balenaEtcher on Micro SD

Install Micro SD On Orange Pi R1

Power on Orange Pi R1

Search IP with Angry IP Scanner on Orange Pi R1

2. Initial Setup

1) Setup Initial Account

### default password of Armbian

userid : root

password : 1234

### Change password of root

New root password: ********
Repeat password: ********

### Create New Account

Please provide a username (eg. your forename): test
Create password: ********
Repeat password: ********

Please provide your real name (eg. John Doe): test

Dear test, your account test has been created and is sudo enabled.
Please use this account for your daily work from now on.

2) Change Network IP

#### Setup Main Ethernet Interface

# nmcli con show
# nmcli con add con-name "Main" ifname  enxc0742bfff848 type ethernet  ip4 192.168.101.101/24 gw4 192.168.101.1
# nmcli con modify Main ipv4.dns 8.8.8.8
# nmcli con modify Main ipv4.dns-search test.com
# nmcli con modify Main ipv4.method manual

#### Setup Sub Ethernet Interface

# nmcli con add con-name "Sub" ifname  eth0 type ethernet  ip4 192.168.1.101/24

#### Remove Ethernet Interface Old IP

# nmcli con delete "Wired connection 2"
# nmcli con delete "Wired connection 1"

#### Connect to Main Interfacs New IP (192.168.101.5)

3) Change hostname & domainname

# hostname
# cp /etc/hostname /etc/hostname.orig
# nano /etc/hostname

Change Configuration

orangepi-r1

==>

r1

# cp /etc/hosts /etc/hosts.orig
# nano /etc/hosts

Change Configuration

127.0.0.1   localhost orangepi-r1
::1         localhost orangepi-r1 ip6-localhost ip6-loopback

==>

127.0.0.1   localhost r1 r1.test.com
::1         localhost r1 r1.test.com ip6-localhost ip6-loopback

# cp /etc/hostname /etc/hostname.orig
# nano /etc/hostname

Change Configuration

orangepi-r1

===>

r1

# shutdown -r now

4) Upgrade all package

$ sudo apt update ; sudo apt dist-upgrade -y ; sudo apt autoremove -y
$ sudo shutdown -r now

5) Setup IP Forwarding 

$ sudo cp /etc/sysctl.conf /etc/sysctl.conf.orig
$ sudo nano /etc/sysctl.conf

Change Configuration

#net.ipv4.ip_forward=1

===>

net.ipv4.ip_forward=1

$ sudo sysctl -p /etc/sysctl.conf
$ sudo shutdown -r now

6) Install UFW(Ubuntu FireWall) (Option)

$ sudo apt install ufw -y
$ sudo ufw enable
$ sudo ufw allow ssh
$ sudo ufw status
$ sudo cp /etc/default/ufw /etc/default/ufw.orig
$ sudo nano /etc/default/ufw

Change Configuration

DEFAULT_FORWARD_POLICY="DROP"

===>

DEFAULT_FORWARD_POLICY="ACCEPT"