NGINX+PHP+MariaDB10+phpMyadmin

Update and upgrade Core

---

yum -y update
yum -y upgrade

Install NGINX

---

yum install epel-release
yum instll nginx

Start NGINX and Enable Service

---

systemctl start nginx
systemctl enable nginx

Install PHP 8.0

---

Enable Remi Repo

yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

Check

yum --disablerepo="*" --enablerepo="remi-safe" list php[7-9][0-9].x86_64
Enable Remi php8.0

yum -y install yum-utils
yum-config-manager --enable remi-php80

install PHP
yum -y install php php-fpm php-mysqlnd php-pgsql php-gd php-imagick php-json php-opcache php-mcrypt php-curl php-mongodb php-mbstring php-intl php-dom php-zip

Edit vim /etc/php-fpm.d/www.conf

user = nginx
group = nginx
listen = /var/run/php-fpm/php-fpm.sock
listen.owner = nginx
listen.group = nginx
listen.mode = 0660

Start and Enable php-fpm

systemctl start php-fpm
systemctl enable php-fpm

Create VirtualHost /etc/nginx/conf.d/test.conf

---

server {
listen 80;
server_name localhost;

root   /usr/share/nginx/html;

location ~ \.php$ {
    try_files $uri =404;
    fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
    fastcgi_index index.php;
    fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script_name;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; #경로 변경 시
    include fastcgi_params;
}

}

Check dan Restart Nginx

nginx -t # 문법
nginx -s reload #
systemctl restart nginx # 서비스 재시작

Testing PHP vim /usr/share/nginx/html/info.php

ex) localhost/info.php

<?php
  echo phpinfo();
?>

Install MariaDB 10 (Centos 7 default using MariaDB 5)

---

wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
chmod +x mariadb_repo_setup
./mariadb_repo_setup
yum install mariadb-server

Configuring and Securing MariaDB Server

systemctl start mariadb
systemctl enable mariadb
sudo mysql_secure_installation or mariadb-secure-installaion

Testing the Installation

mysqladmin -u root -p {password}

Install phpMyAdmin

cd /tmp
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.4/phpMyAdmin-5.0.4-all-languages.zip
unzip phpMyAdmin-5.0.4-all-languages.zip
mv phpMyAdmin-5.0.4-all-languages /usr/share

Update config virtualhost

vim /etc/nginx/conf.d/test.conf
server {
listen 80;
server_name localhost;

root   /usr/share/nginx/html;

location ~ \.php$ {
    try_files $uri =404;
    fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
    fastcgi_index index.php;
    fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script_name;
    include fastcgi_params;
}

location /phpMyAdmin {
    root /usr/share/;
    index index.php index.html index.htm;

    location ~ ^/phpMyAdmin/(.+\.php)$ {
        try_files $uri =404;
        fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
}

    location ~* ^/phpMyAdmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
        root /usr/share/;
}

}

location /phpmyadmin {
    rewrite ^/* /phpMyAdmin last;

}

}

nginx -s reload

---

ERROR

session_start(): open(SESSION_FILE, O_RDWR) failed: Permission denied (13)
session_start(): Failed to read session data: files (path: /var/lib/php/session)

/var/lib/php/session apache -> nginx change

Warning in ./libraries/classes/Config.php#1681
mkdir(): Permission denied

phpmyadmin(install directory) permission chmod 777 phpMyAdmin