نحوه نصب لینوکس، Nginx، MySQL و PHP (پشته LEMP) روی اوبونتو

sudo apt update

sudo apt install nginx

sudo systemctl status nginx

sudo ufw app list

sudo ufw allow 'Nginx HTTP'

sudo ufw status

ip addr show
hostname -I

curl -4 icanhazip.com

http://IP_یا_دامنه

sudo apt install mysql-server

sudo mysql_secure_installation

sudo mysql

exit

sudo apt install php8.1-fpm php-mysql

sudo systemctl status php8.1-fpm
php -v

sudo mkdir /var/www/your_domain
sudo chown -R $USER:$USER /var/www/your_domain

sudo nano /etc/nginx/sites-available/your_domain

server {
    listen 80;
    server_name your_domain www.your_domain;
    root /var/www/your_domain;

    index index.html index.htm index.php;

    location / {
        try_files $uri $uri/ =404;
    }

    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php8.1-fpm.sock;
    }

    location ~ /\.ht {
        deny all;
    }
}

sudo ln -s /etc/nginx/sites-available/your_domain /etc/nginx/sites-enabled/
sudo unlink /etc/nginx/sites-enabled/default

sudo nginx -t
sudo systemctl reload nginx

nano /var/www/your_domain/index.html

<h1>Hello World!</h1>
<p>This is the landing page of your_domain.</p>

nano /var/www/your_domain/info.php

<?php
phpinfo();

http://IP_یا_دامنه/info.php

sudo rm /var/www/your_domain/info.php

sudo mysql

CREATE DATABASE example_database;
CREATE USER 'example_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL ON example_database.* TO 'example_user'@'%';
exit

CREATE TABLE example_database.todo_list (
 item_id INT AUTO_INCREMENT,
 content VARCHAR(255),
 PRIMARY KEY(item_id)
);

nano /var/www/your_domain/todo_list.php

<?php
$user = "example_user";
$password = "password";
$database = "example_database";
$table = "todo_list";

try {
  $db = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
  echo "<h2>TODO</h2><ol>";
  foreach($db->query("SELECT content FROM $table") as $row) {
    echo "<li>" . $row['content'] . "</li>";
  }
  echo "</ol>";
} catch (PDOException $e) {
  echo "Error: " . $e->getMessage();
}

http://IP_یا_دامنه/todo_list.php

sudo systemctl restart php8.1-fpm nginx