How to Install LAMP server and PHPMyAdmin on Ubuntu 20.04 LTS | Suresh Agrawal

Step by step installation and configuration of Apache, MySQL and PHP on Ubuntu 20.04 LTS, Execution of first PHP programs, How to use PHPMyAdmin and many more in Hindi

►Click here to subscribe – youtube.com/nsgacademy

►Download NSG Academy Android App – rb.gy/skn8vc

►TimeStamps –
00:00 – Introduction of this video
00:53 – Settings before LAMP installation
03:35 – Install Apache Web Server
06:00 – Install MySQL Database Server
08:00 – Install PHP
09:18 – How to create and run first PHP program
14:50 – Install PHPMyAdmin
18:45 – Set MySQL root password and create new privileged user
23:25 – How to use PHPMyAdmin
26:20 – Thanks😊

►Installation Steps with all required commands –

Update apt tool either by
1) Software updater
2) Through terminal
sudo apt update
Enter your System root password
sudo apt upgrade
Press Y to continue
CHECK once again by entering following commands
sudo apt update
sudo apt upgrade
sudo apt autoremove
Press Y to continue
Don’t forget to reset machine and verify again

Step -1.
Install Apache Web Server on ubuntu 20.04 LTS :
sudo apt install apache2 -y

CHECK : Whether Apache web server is successfully installed or not
So, goto browser and type anyone form following in address bar
localhost/
127.0.0.1/
your_machine_ip_address/

Enable firewall settings by following commands :
sudo ufw status
sudo ufw enable
sudo ufw app list
sudo ufw allow in "Apache Full"

Step - 2
Install mysql-server on ubuntu 20.04 LTS :
sudo apt install mysql-server
press Y to continue
CHECK : Login mysql with root user without password with sudo
sudo mysql

create database db_name;
use db_name;
select database();
exit

Step - 3.
Install php and its required libraries:
sudo apt install php php-mysql libapache2-mod-php
Press Y to continue
php -v

Create one sample php file in Apache Web server root directory
cd /var/www/html
sudo gedit file_name.php

Goto browser and run
localhost/file_name.php

PERMISSION for apache root directory
sudo chown -R $USER:$USER /var/www/html

To enable right click - new document
touch ~/Templates/Empty Document

Create a php file without sudo through terminal using gedit
gedit file_name.php

Goto browser and run
localhost/file_name.php


Step - 4.
Install PHPMyAdmin
sudo apt update
sudo apt install php-mbstring php-zip php-gd php-json php-curl
Press Y to continue
sudo apt install phpmyadmin
Press Y to continue
Select Apache2 by pressing space and then press tab and OK
Press Yes and set password for dummy user phpMyAdmin
sudo systemctl restart apache2

CHECK : Whether phpMyAdmin is successfully installed or not
So, goto browser and type
localhost/phpmyadmin
Default user name : phpMyAdmin
And enter your password


sudo apt update
Set root password and create a new database user with full privileges
sudo mysql
SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH caching_sha2_password BY ‘password’;
SELECT user,authentication_string,plugin,host FROM mysql.user;
exit
sudo mysql -p
Enter your password
CREATE USER ‘new_user’@‘localhost’ IDENTIFIED WITH caching_sha2_password BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘new_user’@‘localhost’ WITH GRANT OPTION;
exit


Once again
sudo systemctl restart apache2
sudo systemctl restart mysql

Goto web browser and type
localhost/phpmyadmin
Enter new user name and password
And create some databases, table and execute some queries through GUI

Follow NSG Academy on Social Media
►Facebook – facebook.com/nsgacademypune
►Instagram – instagram.com/nsgacademy/
►Twitter – twitter.com/nsgacademy_pune

Visit NSG Academy
►Website – nsgacademy.in
►Google – g.page/nsgacademy_pune

Follow me On Social Media
►Personal Facebook A/c – facebook.com/suresh.agrawal.963871
►Personal Instagram A/c – instagram.com/suresh.rp.agrawal/