Raspberry PI web server with PHP and MySQL
This is the first video in my journey to create a Raspberry Pi into a network monitor. This video creates a simple Raspberry Pi web server with PHP, MySQL, Apache, and PHPMyAdmin. I am including the commands I typed along the way so if you follow along you can cut and paste.
If you enjoy the content considering donating a cup of coffee at https://ko-fi.com/cheapcontrols
User pi password raspberry
sudo apt update
sudo apt upgrade
sudo apt update
sudo apt-get install openssh-server
sudo service ssh restart
Type ifconfig and get the inet address. example 192.168.1.1
-------------------- INSTALL APACHE -------------------------------
sudo apt install apache2
sudo chown -R pi:www-data /var/www/html/
sudo chmod -R 770 /var/www/html/
Check to see if apache is running
Go to a browser and test 192.168.1.1
-------------------- INSTALL PHP -------------------------------
sudo apt install php php-mbstring
!!!!!! NOTE there is a command here that I had to delete because of angled brackets.
------------ NOTE: If you go to my Patreon page you can download this document.
You will have to pause the video and get it from there.
Go to a browser and test 192.168.1.1/index.php
------------------ INSTSALL MYSQL ----------------------------
sudo apt install mysql-server php-mysql
sudo apt install phpmyadmin
------------------ CONFIGURE MYSQL -----------------------
sudo mysql --user=root
DROP USER 'root'@'localhost';
CREATE USER 'root'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'root'@'localhost';
exit
sudo mysql --user=root --password=password
exit
Go to a browser and test 192.168.1.1/phpmyadmin
Join me on twitter @cheapcontrols to hear about new videos
Visit my Patreon page at / cheapcontrols
OR www.cheapcontrols.com to support these videos.
Links clicked on the Cheap Controls homepage help support creating these videos.