ubuntu nginx php mysql 구축

개발 환경 :  ubuntu 18, php7.4, mysql 8.0

 

1. Mysql 설치

apt-get update
apt-get -y install mysql-server mysql-client
mysql -u root -p

 

create database HDVP;

create user 'HDVP'@'%' identified by '&HDVP@1234@HDVP';

grant all on HDVP.* to 'HDVP'@'%';

flush privileges;

use HDVP;

create table users (
         idx int not null auto_increment primary key,
         id char(20),
         name varchar(100),
         pw char(20)
         );

insert into users(id, name, pw) values('admin', '관리자', 'toor');
mysql -u HDVP -p

/etc/mysql/mysql.conf.d

vi mysqld.conf

bind-address            = 0.0.0.0
x   = 0.0.0.0

 

service mysql start

 

2. nginx + php 설치

apt-get -y install nginx

service nginx start

apt-get -y install php7.4-fpm

cd /etc/nginx/
vi nginx.conf

 

cd /etc/nginx/sites-available/
vi default

# 아래와 같이 수정 server {     listen 80;     listen [::]:80;     root /var/www/html;     index index.php index.html index.htm;     location / {         try_files $uri $uri/ /index.php?$query_string;     }     location ~ \.php$ {         include fastcgi_params;         fastcgi_split_path_info ^(.+\.php)(/.+)$;         fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;         fastcgi_index index.php;         fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;     } } server {     listen 80;     listen [::]:80; }

 

 

cd /etc/php/7.4/fpm/
vi php.ini        40% 즘

service php7.4-fpm reload
service nginx reload

cd /var/www/html/

vi info.php
<?php
phpinfo();
?>

 

http://ip주소/info.php

 

apt-cache search php7.4

apt-get -y install php7.4-mysql php7.4-curl php7.4-gd php7.4-intl php-pear php-imagick php7.4-imap
     php7.4-mcrypt php-memcache  php7.4-pspell php7.4-recode php7.4-sqlite3 php7.4-tidy
     php7.4-xmlrpc php7.4-xsl php7.4-mbstring php-gettext

apt-get -y install php-apcu

service php7.4-fpm reload

 

 index.php

<?php $conn = mysqli_connect(   'localhost',   'HDVP',   '&HDVP@1234@HDVP',   'HDVP'); $sql = "SELECT * FROM users WHERE id = 'admin'"; $result = mysqli_query($conn, $sql); $row = mysqli_fetch_array($result); echo $row['id']; echo '<h1>'.$row['name'].'</h1>'; ?>