Install Lemp nginx mysql php fpm Stack on Debian 11 with repository

Note: we install latest versions form debian repository only not form ngninx , mtsql official repos

Pros: Easy to install cons: not latest packages

sudo apt update && sudo apt upgrade

sudo apt install nginx

sudo apt install php8.1-fpm

or  sudo apt install php-fpm  (7.4 latest version)

sudo apt install mysql  (only mariadb-server)

sudo apt install mysql-server

sudo apt install mysql-server-8.0 E: Package ‘mysql-server-8.0’ has no installation candidate

we are adding mysql 8 debian repository from mysql source (install mysql on ubuntu)

https://dev.mysql.com/downloads/repo/apt/

wget https://dev.mysql.com/get/mysql-apt-config_0.8.26-1_all.deb

sudo dpkg -i mysql-apt-config_0.8.26-1_all.deb

select ok

sudo apt-get update && sudo apt-get install mysql-server

enter password mysq8 sha5 based or legacy password

root@instance-1:~# service mysql status
● mysql.service – MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
Active: active (running) since Tue 2023-08-29 07:00:36 UTC; 14s ago

check latest package versions available in Debian repository

apt-cache policy <packageName>

apt-cache policy nginx

apt-cache policy nginx

Reading state information… Done
E: Unable to locate package php8.1-fpm
E: Couldn’t find any package by glob ‘php8.1-fpm’
root@instance-1:~#

nginx:
Installed: (none)
Candidate: 1.18.0-6.1+deb11u3
Version table:
1.18.0-6.1+deb11u3 500  nginx latest version  ( nginx-1.25.2) too old
500 https://deb.debian.org/debian bullseye/main amd64 Packages
500 https://deb.debian.org/debian-security bullseye-security/main amd64 Packages

checking it on ubunut 20.04 LTS

root@murali:~# apt-cache policy nginx
nginx:
Installed: 1.18.0-6ubuntu14.3
Candidate: 1.18.0-6ubuntu14.4
Version table:
1.18.0-6ubuntu14.4 500
500 http://mirrors.digitalocean.com/ubuntu jammy-updates/main amd64 Packages
*** 1.18.0-6ubuntu14.3 500
500 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages
100 /var/lib/dpkg/status
1.18.0-6ubuntu14 500
500 http://mirrors.digitalocean.com/ubuntu jammy/main amd64 Packages

All Are installed lets do some configuration

nginx configuration

mysql configuration

php -fpm configuartion

backing files form other servers

mysqldump -u root -p spro > /var/www/html/sarkariresultpro.in/spro.sql

zip -r /var/www/html/spro.zip /var/www/html/sarkariresultpro.in/

copy to new server by scp command

1st connect servers then use

scp /var/www/html/spro.zip /var/www/html/

mv /var/www/html/var/www/html/sarkariresultpro.in/ /var/www/html/sarkariresultpro.in/

unzip /var/www/html/spro.zip /var/www/html

or cd var/www/html

unzip spro.zip

import mysql 

create database spro;