# update system and do the upgrade
sudo apt update && sudo apt upgrade && sudo apt dist-upgrade

# install the packages we need
sudo apt install apache2 mysql-server php libapache2-mod-php php-mysql php-mbstring

# make sure the service is running, check the result show "running"
service apache2 status
service mysql status

# go to windows OS and enter c:\Windows\System32\drivers\etc folder.
# adjust hosts file permissions to get edit and write permission.
# add "10.40.22.70 www.cute301.com" to the file "hosts" and save it.

# setup mysql root ID / PASSWORD
# login mysql first
sudo mysql

# execute the command, remember to replace the new_password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';
mysql> flush privileges;

# exit from mysql
mysql> exit

# initial mysql installation
sudo mysql_secure_installation

# enter "y" to these questions
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

# go the home dir of cute301 and download phpmyadmin
cd
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.zip

# install zip unzip packages
sudo apt install zip unzip

#extract the zip files
unzip phpMyAdmin-5.2.1-all-languages.zip

# move phpmyadmin to the website dir
sudo mv phpMyAdmin-5.2.1-all-languages /var/www/html/tool

# add new mysql accoun, wpmaster / new_password with default Authentication plugin
# And auto generate pwd

# or add manually by mysql
# Login mysql
mysql -uroot -p
# create account (wordpress/abcWE@s123)and require mysql database "wordpress"
CREATE USER 'wordpress'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abcWE@s123';GRANT USAGE ON *.* TO 'wordpress'@'localhost';ALTER USER 'wordpress'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `wordpress`;GRANT ALL PRIVILEGES ON `wordpress`.* TO 'wordpress'@'localhost';

# download WordPress
wget https://tw.wordpress.org/latest-zh_TW.zip

# unzip it
unzip latest-zh_TW.zip

# move wordpress to the right directory
mv wordpress /var/www/html/wordpress

# 查看 apache2 用什麼帳號在執行
ps aux | egrep '(apache|httpd)'

# adjust the directory permission
chown -R www-data:www-data /var/www

# 用 browser 進入 wordpress
http://locahost:8080/wordpress

# 第一次進入需要建立帳號密碼與輸入 db 資料!!