How to setup Apache, MySql, and PHP on Lubuntu

Web server bekerja pada protokol http (hypertext transfet protocol) yang merupakan
salah satu protocol yang ada di layer 7 (OSI-Presentation) atau layer 4 (TCP/IP). video kali ini kita akan menginstal web server di sistem operasi linux (lubuntu) tetapi kalo hanya install web server sangat nanggung karena tidak akan terlalu berguna. Oleh karena itu kita sekalian menginstall basisdata & compiler php nya. Jadi kita menginstall LAMP (Lubuntu Apache Mysql PHP)
bagaimana setup nya?? Mari kita lihat di video channel ini.

prasyarat :
1. install virtual box

2. run lubuntu on virtualbox

3. virtual box – set fullscreen OS guest Lubuntu

command:
1. sudo su
2. sudo apt-get install tasksel
3. sudo tasksel
4. select lamp server
5. install secure mysql
sudo mysql_secure_installation
6. setting user
mysql -u root -p
7. cek user apa saja yang ada
SELECT user,authentication_string,plugin,host FROM mysql.user;
8. ubah ke mysql native
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
9. FLUSH PRIVILEGES;
10. SELECT user,authentication_string,plugin,host FROM mysql.user;
11. exit;
12. login as root & add user
mysql -u root -p
13. create user
CREATE USER ‘test’@’localhost’ IDENTIFIED BY ‘Test123*#’;
14. set privileges
GRANT ALL PRIVILEGES ON test_db.* TO ‘test’@’localhost’;
15. ubah ke mysql native
alter user ‘test’@’localhost’ identified with mysql_native_password by ‘Test123*#’;
16. drop user mysql
DROP USER ‘test’@’localhost’
17. exit;
18. install phpmyadmin
sudo apt-get install phpmyadmin
19. Choose apache2

material:
1. Virtual box:
VirtualBox-6.1 for Windows
2. Sistem Operasi Host:
Windows 10 – 64bit
3. Sistem Operasi Guest:
Lubuntu 19.04 – 64bit
4. Web Server: apache 2.4.29
5. Php 7.2.24
6. Database: mysql 5.7.34
7. Phpmyadmin 4.6.6

link unduh:
1. virtualbox
https://www.virtualbox.org/wiki/Downloads
2. ubuntu:
https://ubuntu.com/download/desktop

#linux
#lamp
#lubuntu
#apache
#mysql
#php
#opensource
#doctor_of_melodic

source

centos 7