Some links in this post may be affiliate links. We may get paid if you buy something or take an action after clicking one of these, but without addictional costs for you compared to direct buying.

LAMP server on Raspberry PI

Raspberry pi LAMP server featured image
5
(15)

Raspberry PI boards can perform very well to provide complete web server functions with very small budgets. They also have very low power consumption, so many people can start a web page with affordable costs.

LAMP are servers composed by following elements (each one composing LAMP acronym):

  • Linux – Operating System – to manage hardware integration and general software operations
  • Apache – Web Server Application – to expose html pages
  • MySQL – Database – to store records and data which need to be managed with apposite structures
  • Php – Server-side Scripting – to create dynamic pages

Beside installing LAMP server to publish a website, you need to set also some networking configurations.

The very first thing to configure is assuring hat your Raspberry PI will acquire always the same IP address on every boot. This can be achieved by setting a static IP address on Raspberry PI and configuring your router to leave the same IP address associated to RPI Mac Address (this part depends on your router model).

If you want to publish your web page on internet, you also need configure your router port-forwarding. You must forward external ports 80 (for http) and/or 443 (for https) to Raspberry PI. You should also use a domain, being also able to start with a free No-IP domain (please refer to configure No-IP DUC guide for last part).

In this tutorial, I’m going to show you how to install a LAMP server in your Raspberry PI. I’m going to use a cheap Raspberry PI Zero W, but this guide will apply to all Raspberry PI boards.

What We Need

As usual, I suggest adding from now to your favourite e-commerce shopping cart all needed hardware, so that at the end you will be able to evaluate overall costs and decide if continuing with the project or removing them from the shopping cart. So, hardware will be only:

Check hardware prices with following links:

Amazon raspberry pi boards box
Amazon raspberry pi Zero W box
Amazon Micro SD box
Amazon Raspberry PI Power Supply box

Step-by-Step Procedure

Install Operating System – Linux

We’ll use a light OS without desktop environment (headless), so having more power for services instead of wasting CPU and RAM on not needed desktop gui. For this preparation part, please refer to install Raspberry PI OS Lite. If you want anymore a Desktop environment to use your RPI as Personal Computer together with webserver services, then you can install Raspberry PI OS Desktop, proceding with next steps from internal terminal.

Make your operating system up-to-date:

sudo apt update -y && sudo apt upgrade -y

Install Web Server – Apache

Apache is a fast HTTP server providing advanced functionalities to expose web pages. It is the most spread software used on web to publish pages. It is available from all package repositories, so making simple its installation. From terminal, issue following command:

sudo apt install apache2 -y

Once installation is finished, you can check that Apache is working by using your web browser with URL equal to “http://” followed by your Raspberry PI’s IP address. Following picture shows expected result (192.168.1.77 is my RPI IP address):

Apache debian default page

Install PhP

Also Php is so spread that it is available from all package repositories. To proceed with its installation, use following from terminal:

sudo apt install php -y

To check if installation finished correctly, you can issue following command from terminal (with result):

pi@raspberrypi:~ $ php -v
PHP 7.3.19-1~deb10u1 (cli) (built: Jul 5 2020 06:46:45) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.19, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.3.19-1~deb10u1, Copyright (c) 1999-2018, by Zend Technologies

You can also test php and get system info by creating a simple php page in your web server. From terminal, create test.php in /var/www/html/ folder with following command:

sudo nano /var/www/html/test.php 

Add following line:

<?php phpinfo(); ?>

Save and exit. Back to your browser, append “/test.php” to Raspberry PI’s IP address, getting following result:

php info page

Install Database – MariaDB instead of MySQL

From database side, I suggest to use MariaDB instead of MySQL. MariaDB is a fork of MySQL, resulting in a lighter software (which better fits Raspberry PI resources) and keeping same MySQL commands valid. We’ll install together with php connector, so that MariaDB and Php will be already able to communicate. From terminal:

sudo apt install mariadb-server php-mysql -y

Once finished, a common best practice for databases is securing it. MariaDB gives you a procedure to set main configurations. From terminal:

sudo mysql_secure_installation

Following questions will be asked (followed by my suggested answers):

  • Enter current password for root (enter for none):
    • root password in fresh installation is empty, so simply press ENTER key or use your root password
  • Set root password? [Y/n]
    • I suggest to answer Y (yes)
  • New password:
    • type your new root password
  • Re-enter new password:
    • type again your new root password
  • Remove anonymous users? [Y/n]
    • I suggest to answer Y (yes)
  • Disallow root login remotely? [Y/n]
    • I suggest to answer Y (yes)
  • Remove test database and access to it? [Y/n]
    • I suggest to answer Y (yes)
  • Reload privilege tables now? [Y/n]
    • Answer yes to make your answers effective

Your LAMP server is now ready!

Simplify Database management – Phpmyadmin

A useful tool to manage database in LAMP server is phpMyAdmin. It can be installed with following terminal command:

sudo apt install phpmyadmin -y

In phpmyadmin setup screens I suggest the following:

  • select apache (mandatory) with space and press Ok
  • select Yes to configure database for phpmyadmin with dbconfig-common
  • insert your favourite phpmyadmin password and press Ok
  • insert again your phpmyadmin password to confirm and press Ok

Grant phpmyadmin user DB privileges to manage DBs:

We’ll connect to MariaDB with root user (defult password is one before set) to grant permissions (remember to use semicolumns at the end of each command row as showed below):

sudo mysql -uroot -p
grant all privileges on *.* to 'phpmyadmin'@'localhost';
flush privileges;
quit

From here, use your web browser to reach phpMyAdmin login page by using Raspberry PI’s IP address followed by “/phpmyadmin/”:

phpmyadmin login page

Use “phpmyadmin” as username and the password you just set during phpmyadmin installation. You will reach phpMyAdmin home page:

phpmyadmin home page

Next Steps

You can now need to secure your web server. If you don’t need an external Certification Authority, you can use Self Signed Certificate tutorial.

Enjoy!

How useful was this post?

Click on a star to rate it anonymously!

Average rating 5 / 5. Vote count: 15

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

15 comments

  1. Thankyou for the guide.
    Currently there appears to be an issue with versions phpMyAdmin and PHP, arising from the “sudo apt install phpmyadmin” command installing an older version that throws errors with PHP 7.3.
    Hopefully the packages will be updated soon.

    1. I wasn’t able to reproduce your issue, as I just re-installed it from fresh OS. It seems strange, as also latest phpmyadmin version requires only php7.2.5 or newer (please refer to https://docs.phpmyadmin.net/en/latest/require.html#php) and apt currently installs php 7.3. However, if you strictly need php7.4, you can try with a trick included in my Grocy tutorial (https://peppe8o.com/manage-your-home-stocks-like-a-pro-with-grocy-and-raspberry-pi/)

  2. Hey, really good description, thank you!

    Before I could access phpmyadmin in the browser, I had to make following steps:

    edit the “Apache2.conf” file:
    sudo nano /etc/apache2/apache2.conf
    add the following line to the bottom of this file:
    Include /etc/phpmyadmin/apache.conf
    Exit with crtl+X
    Now we need to restart the Apache service:
    sudo service apache2 restart

    And so will work phpmyadmin.

    1. Thank you for your notes. Sometimes package updates can change or add some additional configurations. I’ll test your edit notes and add them in my tutorial soon

  3. Lord, I was able to follow you. Thanks a lot. All my attempts to activate a PHP website to the Raspberry Pi local host failed, can you help me?

      1. Sir. Thanks you so much for seeing the quick response,
        As an XMPPP Home Server for Windows I currently have the RFID Attendance Systems PHP website. I want to set it up as a Raspberry Pi home server, that website is taken from the internet. I will post its link here. I do not know how to connect this site to the lamp server. Can you explain the step-by-step procedure?

        This is the website download link
        https://drive.google.com/file/d/1P5c8MwKc_BlDYW9ApiZG-tF7qUJABQSx/view

        1. Sorry, for this week I can’t test on my Raspberry PI computer boards as I’m on holiday and I’ve only a Raspberry PI Pico with me. But let me have a clear overview of what you have.
          First of all, I want to ask you if you have an XMPP server or a XAMPP server, as the two things are quite different, just to be sure we are on same page.
          Also consider that Windows computers usually have x64 or x86 CPU architecture, while RPI has an ARM CPU architecture. It is not always granted that you can perform this move without reinstalling some things. Another check is if your current php version on Windows server is compatible (or the same) with the two currently available from Raspberry PI OS repository (2.7 and 3.7, latter whould be better solution).
          The simplest way to verify if it works (if you are very very lucky) is copying the entire content from your Windows root publishing path (usually C:/xampp/htdocs/) into the LAMP root publishing path (/var/www/html/), then setting correct permissions to allow ownership to www-data:www-data.
          But if you had in past to install something and/or you use a database, this won’t give a working result…

          1. Sir, I know that the web version is stored in the htdocs folder in Xampp, but the htdocs folder is not found in the lamp server, how do I find it?

  4. when I run;
    [ grant all privileges on *.* to ‘phpmyadmin’@’localhost’; ]

    I keep getting this error.

    ERROR 1133 (28000): Can’t find any matching row in the user table

    everything else has been working just fine

Leave a Reply

Your email address will not be published. Required fields are marked *

I accept the Privacy Policy