LEMP Stack

LEMP Stack stands for Linux , Nginx , Mysql, and Php. The instructions here go further and add myphpadmin, composer and on the nginx docs page , Modsecurity WAF.

Install

``` sudo apt update && sudo apt upgrade

See Decyphertek - nginx docs how how to install nginx with Modsecurity WAF.

Install mysql - See Decyphertek - mysql docs on how to manage mysql

sudo apt install mysql-server sudo mysql

set a root mysql password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql> exit

Debian generates a nonsecure password stored here - /etc/mysql/debian.cnf

sudo cat /etc/mysql/debian.cnf sudo mysqladmin -u debian-sys-maint -p'oldPassword' password 'newPassword'

Update the password in the debian.cnf as well.

sudo vim /etc/mysql/debian.cnf sudo mysql_secure_installation

Verify your passwords work

mysql -u root -p mysql>exit mysql -u debian-sys-maint -p mysql>exit

Install PHP

sudo apt install php-mysql php-fpm php-curl php-gd php-mbstring php-xml php-xmlrpc php-cli

Optional: Install myphpadmin

Requires a lot of setup to secure an get working with nginx, see Digital Ocean docs referenced.

sudo apt-get -y install apt-transport-https ca-certificates curl curl -fsSL "https://keyserver.ubuntu.com/pks/lookup?op=get&search=0x42636ff8dae547240e01a1ca2ea3055293cb3f45" | sudo gpg --dearmor -o /usr/share/keyrings/phpmyadmin-ppa.gpg sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/phpmyadmin-ppa.gpg] https://ppa.launchpadcontent.net/phpmyadmin/ppa/ubuntu jammy main" > /etc/apt/sources.list.d/phpmyadmin-ubuntu-ppa-jammy.list' sudo apt update sudo apt install -y phpmyadmin

install PHP Composer

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" php -r "if (hash_file('sha384', 'composer-setup.php') === '55ce33d7678c5a611085589f1f3ddf8b3c52d662cd01d4ba75c0ee0459970c2200a51f492d557530c71c15d8dba01eae') {echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;" php composer-setup.php php -r "unlink('composer-setup.php');" sudo mv composer.phar /usr/local/bin/composer

start using composer

composer list

Update Composer

composer self-update

References

https://www.linode.com/docs/guides/how-to-install-a-lemp-stack-on-ubuntu-22-04/
https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-22-04
https://www.linode.com/docs/guides/installing-and-using-php-composer/
https://github.com/phpmyadmin/phpmyadmin/wiki/DebianUbuntu
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-nginx-on-an-ubuntu-20-04-server