Hello From Your Web Server!

1
#!/bin/bash
yum -y install httpd
systemctl enable httpd
systemctl start httpd
echo '<html><h1>Hello From Your Web Server!</h1></html>' > /var/www/html/index.html
dnf install mariadb105 -y




2

rds=database-2.c1gecq0s0wvn.ap-northeast-2.rds.amazonaws.com



mysql -h $rds -uadmin -p


show databases;




3


CREATE DATABASE mydatabase;


SHOW DATABASES;


USE mydatabase;


CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);



SHOW TABLES;
DESC users;



INSERT INTO users (name, email) VALUES ('홍길동', 'hong@example.com');
INSERT INTO users (name, email) VALUES ('김철수', 'kim@example.com');


SELECT * FROM users;