Untuk menginstal LEMP stack (Linux, Nginx, MySQL/MariaDB, PHP) di Debian 12 dengan PHP 8.2 dan MariaDB untuk menjalankan aplikasi PHPMaker, ikuti langkah-langkah berikut:
sudo apt update && sudo apt upgrade
sudo ufw allow http
sudo ufw allow https
sudo ufw status
Install PHP8.2
sudo apt install php-fpm php-cli php-mysql php-mbstring php-xml php-gd php-curl php-intl
Install MariaDB
sudo apt install mariadb-server
mysql –version
PHP 8.2.7 (cli) (built: Jun 9 2023 19:37:27) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.7, Copyright (c) Zend Technologies
with Zend OPcache v8.2.7, Copyright (c), by Zend Technologies
sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we’ll need the current password for the root user. If you’ve just installed MariaDB, and haven’t set the root password yet, you should just press enter here. Enter current password for root (enter for none):
OK, successfully used password, moving on… Setting the root password or using the unix_socket ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have your root account protected, so you can safely answer ‘n’. Switch to unix_socket authentication [Y/n] n
… skipping. You already have your root account protected, so you can safely answer ‘n’. Change the root password? [Y/n] n
… skipping. By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.
Remove anonymous users? [Y/n] y … Success!
Normally, root should only be allowed to connect from ‘localhost’. This ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y … Success!
By default, MariaDB comes with a database named ‘test’ that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment.
Remove test database and access to it? [Y/n] y – Dropping test database… … Success! – Removing privileges on test database… … Success!
Reloading the privilege tables will ensure that all changes made so far will take effect immediately.
Reload privilege tables now? [Y/n] y … Success! Cleaning up…
All done! If you’ve completed all of the above steps, your MariaDB installation should now be secure.
Thanks for using MariaDB!
Configure MariaDB
sudo mysql
MariaDB> CREATE DATABASE exampledb;
MariaDB> CREATE USER ‘exampleuser’@’localhost’ IDENTIFIED BY ‘YourPassword2!’;
MariaDB> GRANT ALL PRIVILEGES ON exampledb.* TO ‘exampleuser’@’localhost’;
MariaDB> GRANT ALL ON *.* TO ‘navjot’@’localhost’ IDENTIFIED BY ‘Yourpassword32!’ WITH GRANT OPTION;
MariaDB> FLUSH PRIVILEGES;
MariaDB> exit
sudo mysql -u exampleuser -p
Install Nginx
apt -y install nginx
nano /etc/nginx/sites-available/default
Configure PHP-FPM
sudo nano /etc/php/8.2/fpm/php.ini
upload_max_filesize = 50M … post_max_size = 50M
memory_limit = 256M
Mengonfigurasi Nginx untuk Menggunakan Prosesor PHP
sudo mkdir /var/www/your_domain
sudo chown -R $USER:$USER /var/www/your_domain
sudo nano /etc/nginx/sites-available/your_domain
Configure Nginx to Use PHP-FPM:
Create a virtual host configuration file in /etc/nginx/sites-available/test.conf. Kindly replace test.example.com with your actual domain.
server {
listen 80;
server_name test.example.com www.test.example.com;
root /var/www/test.example.com;
location / {
index index.php index.html;
try_files $uri $uri/ /index.php?$query_string;
}
location ~ \.php$ {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php8.2-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/myapp.conf (apabila hapus link)
sudo nginx -t
systemctl reload nginx
systemctl restart nginx
Contoh server yang menggunkan lemp diatas adalah : https://lppm.simpel.uncen.ac.id
sumber :
https://www.howtoforge.com/how-to-install-lemp-stack-nginx-php-and-mariadb-on-debian-12/
https://www.server-world.info/en/note?os=Debian_12&p=nginx&f=1
https://techviewleo.com/nginx-php-and-php-fpm-on-debian/