tatumroaquin/lemp-stack.md

Last active June 24, 2021 01:40

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tatumroaquin/1708415a5ee5be07e3138c6d7ae07dc2.js"></script>
Save tatumroaquin/1708415a5ee5be07e3138c6d7ae07dc2 to your computer and use it in GitHub Desktop.

Download ZIP

simple LEMP stack web server

Raw

lemp-stack.md

Arch Linux LEMP Stack

Install NGINX Web Server

sudo pacman --noconfirm -S nginx
sudo vim /etc/nginx/nginx.conf

// Modify the following
location / {
   root           /usr/share/nginx/html;
   index          index.html index.php;
}

location ~ \.php$ {
   root           /usr/share/nginx/html;
   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;
}

sudo nginx -t
sudo systemctl start nginx
sudo systemctl enable nginx

Install MariaDB/MySQL Database

sudo pacman --noconfirm -S mariadb
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo mysql_secure_installation

// Answer the following, change the root password if needed
Enter current password for root (enter for none): Enter
Switch to unix_socket authentication [Y/n]: Enter
Change the root password? [Y/n]: N
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tablse now? [Y/n]: Y

mysql -u root -p
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password'
GRANT ALL PRIVILEGES ON DBName.* TO 'admin'@'localhost'

SQL Password Reset

// https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
sudo mysql -u root -p
ALTER USER 'user'@'localhost' IDENTIFIED BY 'newpass';
FLUSH PRIVILEGES;

Install PHP Application Server

sudo pacman -S php php-fpm
sudo vim /etc/php/php.ini

// Uncomment the following, phpMyAdmin requires iconv and mysqli
;extensions=iconv
;extensions=mysqli
;extensions=pdo_mysql

sudo systemctl start php-fpm
sudo systemctl enable php-fpm
sudo vim /usr/share/nginx/html/info.php

<?php phpinfo(); ?>

http://localhost/info.php

Install phpMyAdmin CPanel

sudo pacman --noconfirm -S phpmyadmin
sudo ln -s /usr/share/webapps/phpMyAdmin /usr/share/nginx/html/
http://localhost/phpMyAdmin

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment