네이버 클라우드 플랫폼(NCP) 서버 2대를 생성하여 테스트 진행
-DB서버-
MySQL 설치 (5.7버전으로 설치하기)
wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server
systemctl start mysqld
systemctl status mysqld
루트계정 비밀번호 변경
mysql_secure_installation
mysql 로그인 후
create database home;
use home;
create table people( id int NOT NULL AUTO_INCREMENT, name varchar(255), email varchar(255), PRIMARY KEY (id) );
desc people;
보안정책 변경
set global validate_password_policy=LOW;
계정생성 + 권한설정
create user 'root'@'%' identified by 'Root78()';
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'Root78()';
flush privileges;
-Web 서버-
vi /var/www/html/index.html
<html> <body> <form action="form_submit.php" method="post"> Name:<input type="test" name="name"><br> Email:<input type = "email" name="email"><br> <input type="submit"> </form> </body> </html>
vi /var/www/html/form_submit.phb
<?php $name = $_POST['name']; $email = $_POST['email'];
$servername = "localhost"; $username = "root"; $password = "Mysql78()!!@@"; $dbname = "home";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connect sucessfully";
$sql = "INSERT INTO people (name,email) VALUES ('$name','$email')";
if ($conn->query($sql) === TRUE) { echo " New Record created sucessfully"; } else { echo "Error : " . $sql . "<br>" . $conn->error; }
$conn->close(); ?>
웹페이지에서 데이터입력후 DB서버로 들어오는지 확인
-DB 서버-
use home;
select * from people;
'NCP' 카테고리의 다른 글
| [NCP] Terraform을 사용해서 서버 생성하기 (0) | 2022.07.08 |
|---|
