nuy

1.Setting up a remote connection via SSHSSH is a service for connecting remotely to a server and is basically running immediately after the OS is installed, but the default settings are somewhat insecure.Here we will configure the default settings to increase the security of SSH connections.2.Firewall (Firewalld) settingsIn Oracle, the firewall is firewalld configured by default and enabled during OS installation.To briefly explain "firewalld," when setting communication control policies, communication permission/blocking rules are applied to predefined zones, and these zones are then assigned to each NIC (network adapter).

OracleLinux8.10 InstallOracle Linux provides a 100% application binary compatible alternative to Red Hat Enterprise Linux and CentOS Linux for both hybrid and multi-cloud environments.Since 2006, Oracle Linux has been completely free to download and use. Source code, binaries and updates are provided free of charge. It is freely redistributable. Free for use in production environments.We will proceed with the latest updated Oracle Linux 8.10 (released August 29, 2024) with Vo.8.Oracle Linux 8.10 installation image (OracleLinux-R8-U10-x86_64-dvd.iso ) can be downloaded from the following sitehttps://www.oracle.com/linux/The installation process is the same as for OracleLinux8.8, so please refer to the following page.

1.Website data backup1-1.Backup under /var/www/html①Create backup script file2.MySQL database backup①Create backup script file# cd /var/www/system# vi db_my_backup.sh3.Restore backup files under html① Store HTML backup files in "/ (root)" directory# cd /var/www/backup/html_bak# cp html_back_20220610.tar.gz / ←Specify the backup file with the latest date4.Restore Mysql backup file①Save the database backup file to any directory and（In the example, the directory is "/var/www/backup/db_bak".）Extracting data# cd /var/www/backup/db_bak

Mysql8 Install＃ dnf -y install mysql-serverCreate a new charset.cnf with the following contentsWordPress Install1. Create database for Word PressAs an example, assume database [wp_db] database user [wp_user] password [?W123456]

Mysql8 Install＃ dnf -y install mysql-serverCreate a new charset.cnf with the following contentsWordPress Install1. Create database for Word PressAs an example, assume database [wp_db] database user [wp_user] password [?W123456]

1.Website data backup1-1.Backup under /var/www/html①Create backup script file2.MySQL database backup①Create backup script file# cd /var/www/system# vi db_my_backup.sh3.Restore backup files under html① Store HTML backup files in "/ (root)" directory# cd /var/www/backup/html_bak# cp html_back_20220610.tar.gz / ←Specify the backup file with the latest date4.Restore Mysql backup file①Save the database backup file to any directory and（In the example, the directory is "/var/www/backup/db_bak".）Extracting data# cd /var/www/backup/db_bak

Mysql8 Install＃ dnf -y install mysql-serverCreate a new charset.cnf with the following contentsWordPress Install1. Create database for Word PressAs an example, assume database [wp_db] database user [wp_user] password [?W123456]

1.Website data backup1-1.Backup under /var/www/html①Create backup script file2.MySQL database backup①Create backup script file# cd /var/www/system# vi db_my_backup.sh3.Restore backup files under html① Store HTML backup files in "/ (root)" directory# cd /var/www/backup/html_bak# cp html_back_20220610.tar.gz / ←Specify the backup file with the latest date4.Restore Mysql backup file①Save the database backup file to any directory and（In the example, the directory is "/var/www/backup/db_bak".）Extracting data# cd /var/www/backup/db_bak

MySQL8 Install＃ dnf -y install mysql-servercharset.cnf   Create a new one with the fWordPress Install1. Create database for Word PressAs an example, assume database [wp_db] database user [wp_user] password [?W123456]

1.Website data backup1-1.Backup under /var/www/html①Create backup script file2.MySQL database backup①Create backup script file# cd /var/www/system# vi db_my_backup.sh3.Restore backup files under html① Store HTML backup files in "/ (root)" directory# cd /var/www/backup/html_bak# cp html_back_20220610.tar.gz / ←Specify the backup file with the latest date4.Restore Mysql backup file①Save the database backup file to any directory and（In the example, the directory is "/var/www/backup/db_bak".）Extracting data# cd /var/www/backup/db_bak

1. Setting up a remote connection via SSHSSH is a service for connecting remotely to a server and is basically running immediately after the OS is installed, but the default settings are somewhat insecure.Here we will configure the default settings to increase the security of SSH connections.1.1 SSH service configuration file changesThe SSH service configuration file is "/etc/ssh/sshd_config".