Rocky9: Wordpress + PHP8.0 + MySQL8.0
Rocky9에 wordpress와 MySQL을 설치해서 Connection 하는 과정입니다.
2Tier 구성.
1. Rocky9-1
# dnf install -y wget tar httpd
# wget https://ko.wordpress.org/wordpress-5.7.8-ko_KR.tar.gz
# tar xvfz wordpress-5.7.8-ko_KR.tar.gz
# cp -ar wordpress/* /var/www/html/
# cp /var/www/html/{wp-config-sample.php,wp-config.php}
# sed -i 's/DirectoryIndex index.html/DirectoryIndex index.php/g' /etc/httpd/conf/httpd.conf
# dnf install -y php php-common php-opcache php-cli php-gd php-curl php-mysqlnd
# systemctl enable --now httpd
# firewall-cmd --add-port=80/tcp
# sed -i 's/database_name_here/wordpess/g' /var/www/html/wp-config.php
# sed -i 's/username_here/root/g' /var/www/html/wp-config.php
# sed -i 's/password_here/It12345!/g' /var/www/html/wp-config.php
# sed -i 's/localhost/10.0.0.12/g' /var/www/html/wp-config.php
# dnf install -y mysql
2. Rocky9-2
# dnf install -y mysql-server
# systemctl start mysqld
# mysql_secure_installation
mysql> 패스워드 설정 여부: y
mysql> 패스워드 강도: 2
mysql> 패스워드 입력: 8글자 이상, 대소문자, 숫자, 특수기호 -> It12345!
mysql> 적용여부: y
mysql> anonymous 계정 삭제: y
mysql> root 사용자의 원격 로그인 불허: No
mysql> test database 삭제 여부: y
mysql> 권한테이블 reload: y
# mysql -uroot -p
패스워드: It12345!
mysql> select host,user from mysql,user;
mysql> create user 'root'@'%' identified by 'It12345!';
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges
firewall-cmd --add-port=3306/tcp
3. Rocky9-1
# mysql -uroot -pIt12345! -h 10.0.0.12
mysql> create database wordpress;
exit
4. Host PC or VM W10에서 http://10.0.0.11 접속 테스트