Apache php mariadb-client [Amazon Web Services Linux 2023] > 센트리어 포스팅

Apache php mariadb-client [AWS Linux 2023]

vi /etc/selinux/config

SELINUX=disabled

sudo dnf update -y

sudo yum install mod_ssl

sudo apachectl -M | grep ssl

sudo dnf install -y httpd wget php-fpm php-mysqli php-json php php-devel

dnf install mariadb105-server 

sudo systemctl start httpd

sudo systemctl enable httpd

sudo usermod -a -G apache ec2-user 

groups

sudo chown -R ec2-user:apache

sudo chmod 2775 /var/www && find /var/www -type d -exec sudo chmod 2775 {} \; 

find /var/www -type f -exec sudo chmod 0664 {} \;

mariadb server 설치 방법이 바뀌었다.

wget https://dlm.mariadb.com/3/MariaDB/mariadb_repo_setup

sh mariadb_repo_setup 

yum install mariadb-server

참조

google cloud 에서 database

gcloud compute firewall-rules delete allow-mariadb

gcloud compute firewall-rules create allow-mariadb --allow tcp:3306 --source-ranges 0.0.0.0/0 --description "Allow MariaDB access"

외부 연결 테스트

sudo firewall-cmd --list-all

mysql -u metadias -p -h 127.0.0.1

mysql -u metadias -p -h 34.64.142.108

nc -zv 34.64.142.108 3306

mariadb -u metadias -p -h 34.64.142.108

sestatus