LAMP - atabegruslan/Notes GitHub Wiki

Setup Web Server

Preliminary

If you don't have a real server, you can use VirtualBox: https://github.com/atabegruslan/Notes/wiki/Terminal-into-Virtual-Machines

Setup Web Server (old fashioned way)

Follow this remote LAMP installation tutorial: https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04

Just for comparison, this is how you install LAMP when you are at the computer: https://howtoubuntu.org/how-to-install-lamp-on-ubuntu

While doing this, make sure the virtual machine can access internet.

Install Apache

# Install Apache
sudo su
apt update
apt install apache2
# Adjust the Firewall to Allow Web Traffic (http & https)
ufw app list
ufw app info "Apache Full"
ufw allow in "Apache Full"

To check that you installed Apache server correctly:

You get the /var/www/html/index.html directory
You can see http://127.0.0.1/

If with virtual machine / port-forwarding

On virtual box -> the virtual machine -> settings -> network -> NAT -> Port forwarding: match 127.0.0.1:8000 to {virtual_machine_ip}:80

Visit http://127.0.0.1:8000/

You can edit the default index page. by vim /var/www/html/index.html

Install MySQL Server

# Install MySQL
sudo su
apt install mysql-server

To check that you installed MySQL server correctly:

If you can enter mysql shell by running sudo mysql, then you installed MySQL server correctly.

Install MySQL Client - PhpMyAdmin

After you install MySQL Server, you have to enter the mysql shell as root, create a new user and give it a password.

Now you can log into mysql shell by running mysql -u sammy -p, and enter "password" when password is prompted.

sudo mysql
mysql> CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;

Or, more fully:

CREATE USER 'sammy'@'localhost' IDENTIFIED WITH caching_sha2_password BY '***';GRANT ALL PRIVILEGES ON . TO 'sammy'@'localhost' WITH GRANT OPTION;ALTER USER 'sammy'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `sammy`;GRANT ALL PRIVILEGES ON `sammy`. TO 'sammy'@'localhost';GRANT ALL PRIVILEGES ON `sammy\_%`. TO 'sammy'@'localhost';

'Cheap' way (Don't use this way when setting up actual server)

Download the .zip from https://www.phpmyadmin.net/downloads/
Unzip the downloaded .zip, rename it to phpmyadmin and move it into /var/www/html/
This is sufficient for you to access http://127.0.0.1/phpmyadmin
You can then use the username and password of the newly created mysql user (step 1)
Visit http://localhost/phpmyadmin and login with "sammy / password"

Proper way

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

Run these commands:

sudo apt update
sudo apt install phpmyadmin
sudo systemctl restart apache2

Visit http://localhost/phpmyadmin and login with "sammy / password"

Uninstall MySQL Server

https://askubuntu.com/questions/172514/how-do-i-uninstall-mysql

sudo systemctl stop mysql
sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt autoremove
sudo apt autoclean

Install PHP

https://thishosting.rocks/install-php-on-ubuntu/

sudo apt install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring php-xml libapache2-mod-php

Install specific PHP versions

sudo apt install -y software-properties-common
sudo add-apt-repository ppa:ondrej/php
sudo apt update
sudo apt install php7.4
sudo apt-get install php7.4-cli php7.4-fpm php7.4-bcmath php7.4-curl php7.4-gd php7.4-intl php7.4-json php7.4-mbstring php7.4-mysql php7.4-opcache php7.4-sqlite3 php7.4-xml php7.4-zip

Switch PHP versions

sudo update-alternatives --set php /usr/bin/php7.0 
sudo update-alternatives --set phar /usr/bin/phar7.0 
sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.0 
sudo update-alternatives --set phpize /usr/bin/phpize7.0 
sudo update-alternatives --set php-config /usr/bin/php-config7.0 
sudo a2dismod php7.1 
sudo a2enmod php7.0 
sudo service apache2 restart 

sudo update-alternatives --set php /usr/bin/php7.1 
sudo update-alternatives --set phar /usr/bin/phar7.1 
sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.1 
sudo update-alternatives --set phpize /usr/bin/phpize7.1 
sudo update-alternatives --set php-config /usr/bin/php-config7.1 
sudo a2dismod php7.0 
sudo a2enmod php7.1 
sudo service apache2 restart

To check that you installed PHP correctly:

If running php -v returns you the PHP version number, then you installed PHP correctly.
You can also use php -i | grep php.ini to find out the correct php.ini (More details: https://askubuntu.com/questions/356968/find-the-correct-php-ini-file)
Then you can create a PHP info page and visit http://127.0.0.1/info.php to see all the PHP info.

sudo su
cd /var/www/html
touch info.php
echo '<?php phpinfo(); ?>' >> info.php

Apache and PHP log files

By default /var/log/apache2/error.log

Can be configured in /etc/php{version}/apache2/php.ini