Raspberry Pi: Install Apache + MySQL + PHP (LAMP Server)

In this guide, you’ll learn how to install a LAMP (Linux, Apache, MySQL, PHP) server on a Raspberry Pi. LAMP is a software bundle that is used for web development. The Raspberry Pi will have Raspbian OS installed and you’ll use phpMyAdmin to easily manage your database through a web interface.

Install on Raspberry Pi Apache + PHP + MySQL + phpMyAdmin LAMP Server

Prerequisites

Before continuing with this tutorial:

If you like home automation and you want to build a complete home automation system, I recommend downloading my home automation course.

After having your Raspberry Pi board prepared with Raspbian OS, you can continue with this tutorial.

You can either run the next commands on a Raspberry Pi set as a desktop computer or using an SSH connection.

Updating and Upgrading

Before starting the installation procedure, open a Terminal window and run the following commands to update your Pi:

[email protected]:~ $ sudo apt update && sudo apt upgrade -y

Install Apache2 on Raspberry Pi

Apache2 is the most widely used web server software. Briefly, a web server is the software that handles requests to access a web page. Then, depending on the page you have requested, the server will generate the document to serve you (.html, .php, etc).

Apache2 on Raspberry Pi LAMP Server overview

To install Apache2 on your Raspberry Pi, run the next command:

[email protected]:~ $ sudo apt install apache2 -y
Raspberry Pi Install Apache2 LAMP Server

That’s it! Apache is now installed. To test your installation, change to the /var/www/html directory and list the files:

[email protected]:~ $ cd /var/www/html
[email protected]:/var/www/html $ ls -al
index.html

You should have an index.html file in that folder. To open that page in your browser, you need to know the Raspberry Pi IP address. Use:

[email protected]:/var/www/html $ hostname -I
Raspberry Pi change directory RPi IP Address

In my case, the Raspberry Pi IP address is 192.168.1.86. If you open your RPi IP address in any browser in your local network, a similar web page should load (http://192.168.1.86):

Raspberry Pi Apache2 Installed

Install PHP on Raspberry Pi

PHP is a server side scripting language. PHP (Hypertext Preprocessor) is used to develop dynamic web applications. A PHP file contains <?php … ?> tags and ends with the extension “.php“.

To install PHP on Raspberry Pi, run:

[email protected]:/var/www/html $ sudo apt install php -y

You can remove the index.html and create a PHP script to test the installation:

[email protected]:/var/www/html $ sudo rm index.html
[email protected]:/var/www/html $ sudo nano index.php

In your index.php file add the following code to echo the “hello world” message:

<?php echo "hello world"; ?>
Raspberry Pi Create PHP Test File Hello World

To save your file: press Ctrl+X, followed by y, and press Enter to exit.

Finally, restart Apache2:

[email protected]:/var/www/html $ sudo service apache2 restart

To test if Apache2 is serving .php files, open the Raspberry Pi IP address and it should display the “hello world” message from the index.php script created earlier.

Raspberry Pi test PHP File Hello World message web browser

If everything is working, you can remove index.php file from the /var/www/html directory:

[email protected]:/var/www/html $ sudo rm index.php

Install MySQL (MariaDB Server) on Raspberry Pi

MySQL (often pronounced My SQL) is a popular open source relational database.

Install the MySQL Server (MariaDB Server) and PHP-MySQL packages by entering the following command:

[email protected]:/var/www/html $ sudo apt install mariadb-server php-mysql -y
[email protected]:/var/www/html $ sudo service apache2 restart

After installing MySQL (MariaDB Server), it’s recommend to run this command to secure your MySQL installation:

[email protected]:/var/www/html $ sudo mysql_secure_installation

This should appear in your Terminal window:

Raspberry Pi MySQL Database MariaDB Secure Installation
  • You will be asked Enter current password for root (type a secure password): press Enter
  • Type in Y and press Enter to Set root password
  • Type in a password at the New password: prompt, and press Enter. Important: remember this root password, as you will need it later
  • Type in Y to Remove anonymous users
  • Type in Y to Disallow root login remotely
  • Type in Y to Remove test database and access to it
  • Type in Y to Reload privilege tables now

When the installation is completed, you’ll see the message: “Thanks for using MariaDB!”.

Raspberry Pi MySQL Database-MariaDB Final Secure Installation

If you experience any error login into phpMyAdmin, you might need to create a new user to login. Those commands will create a new user with name (admin) and password (your_password).

[email protected]:/var/www/html $ sudo mysql --user=root --password
> create user [email protected] identified by 'your_password';
> grant all privileges on *.* to [email protected];
> FLUSH PRIVILEGES;
> exit;

Install phpMyAdmin on Raspberry Pi

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL using a web interface.

To install phpMyAdmin on a Raspberry Pi, type the following command into the terminal:

[email protected]:/var/www/html $ sudo apt install phpmyadmin -y

PHPMyAdmin installation program will ask you few questions. We’ll use the dbconfig-common.

  • Select Apache2 when prompted and press the Enter key
  • Configuring phpmyadmin? OK
  • Configure database for phpmyadmin with dbconfig-common? Yes
  • Type your password and press OK
Raspberry Pi install phpMyAdmin

Enable the PHP MySQLi extension and restart Apache2 for changes to take effect:

[email protected]:/var/www/html $ sudo phpenmod mysqli
[email protected]:/var/www/html $ sudo service apache2 restart

When you go to your RPi IP address followed by /phpmyadmin (in my case http://192.168.1.86/phpmyadmin), you’ll probably see the “Not Found” error page in your browser:

Failed to open phpMyAdmin Raspberry Pi

If that’s the case, you’ll have to move the phpmyadmin folder to /var/www/html, run the next command:

[email protected]:/var/www/html $ sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

Now, if you list the files, it should return the phpmyadmin folder:

[email protected]:/var/www/html $ ls
phpmyadmin
Raspberry Pi move phpMyAdmin to /var/www/html phpMyAdmin folder

Reload your web page (http://192.168.1.86/phpmyadmin), your should see the login page for phpMyAdmin web interface::

Raspberry Pi Open phpMyAdmin Login Page

Enter your defined username (it should be Username = root) and the password you defined during the installation.

Press the Go button to login. A new page loads:

Raspberry Pi Open phpMyAdmin Logged in Page

That’s it! Your Raspberry Pi board is prepared with a LAMP server: Apache2, MySQL, PHP. We’ve also decided to include phpMyAdmin in this installation for an easier database management through a web interface.

Optional Step (but recommended)

To manage your web pages, you should change the permissions for your /var/www/html/ folder. To do this, run the following commands:

[email protected]:~ $ ls -lh /var/www/
[email protected]:~ $ sudo chown -R pi:www-data /var/www/html/
[email protected]:~ $ sudo chmod -R 770 /var/www/html/
[email protected]:~ $ ls -lh /var/www/

After running these commands, you’ll see something as follows:

Raspberry-Pi change var www html folder

Wrapping Up

We hope you found this guide useful! Your Raspberry Pi has a LAMP server with phpMyAdmin that allows you to build interesting IoT projects like these:

Learn more about Home Automation with the Raspberry Pi: Build a Home Automation System for $100

Thanks for reading.



Build Web Server projects with the ESP32 and ESP8266 boards to control outputs and monitor sensors remotely. Learn HTML, CSS, JavaScript and client-server communication protocols DOWNLOAD »

Build Web Server projects with the ESP32 and ESP8266 boards to control outputs and monitor sensors remotely. Learn HTML, CSS, JavaScript and client-server communication protocols DOWNLOAD »


Enjoyed this project? Stay updated by subscribing our newsletter!

25 thoughts on “Raspberry Pi: Install Apache + MySQL + PHP (LAMP Server)”

  1. Hi, all but completed this, however, I seem to have failed at the last hurdle. I cannot log in to phpMyAdmin with user Root, but I can log on as admin. However, having done so, I don’t have privileges to create a new database. Can you please advise…

    Reply
    • Andrew, had the same problem.
      Could you issue the following commnd in mysql:
      SELECT user,authentication_string,plugin,host FROM mysql.user;
      does that show an output in which there is an authentication plugin used for ‘root’?

      If so, do the following:
      ALTER USER [email protected] IDENTIFIED WITH mysql_native_password;
      SET PASSWORD=PASSWORD(‘yourpassword’);
      FLUSH PRIVILEGES;
      That allowed me to log in as root

      Reply
      • No, I don’t show a : “authentication plugin”, only “unix_socket”.

        #mysql
        MariaDB [(none)]> SELECT user,authentication_string,plugin,host FROM mysql.user;

        Output:

        | user | authentication_string | plugin | host |

        | root | | unix_socket | localhost |
        | phpmyadmin | | localhost |

        Reply
    • To solve the problem, that you can not connect with root at phpmyadmin try the following:

      $sudo mysql -u root

      [(none)]> use mysql;
      [mysql]> update user set plugin=” where User=’root’;
      [mysql]> flush privileges;
      [mysql]> \q

      Make shure after plugin= there are two seperated ‘ (apostophes) not one double-one!

      Reply
  2. By the way, looking at other guides, they suggest logging in with user phpmyadmin – whilst this login does work, it still doesn’t have privileges…

    Reply
  3. I can log in with user as phpmyadmin and password that i set previously.
    What do you meant by still doesn’t have privileges. How to check and confirm the privileges ?

    Reply
  4. I’ve now sorted this 🙂

    In answer to Ong – even though I could log into phpMyAdmin, it wouldn’t allow me to create a database – I basically had read only rights. There was a red warning cross symbol saying No Privileges.

    On installing onto a new Pi 3A+ I realised I’d not launched the mysql server using “sudo mysql” and then entered the following code:
    [email protected]:/var/www/html $ sudo mysql –user=root –password
    > create user [email protected] identified by ‘your_password’;
    > grant all privileges on *.* to [email protected];
    > FLUSH PRIVILEGES;
    > exit;

    This then allowed me (logged in as andrew) to create the database and complete the project

    Reply
  5. Can’t log in with either root or admin.
    With root:
    #1698 – Access denied for user ‘root’@’localhost’
    ! mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’

    With admin:
    #1045 – Access denied for user ‘admin’@’localhost’ (using password: YES)
    !mysqli_real_connect(): (HY000/1045): Access denied for user ‘admin’@’localhost’ (using password: YES)

    Otherwise, fantastic job!!

    Reply
  6. Disclaimer:
    Totally new to installing and using db’s

    Darn, I was getting all the for mentioned errors. And I implemented several of the suggested solutions, but, I was still getting the errors. So, I decided to do the old reboot trick and it worked. Wish I could say what exactly fixed it.

    After rebooting, from the browser page, tried to login again and it failed when I used [email protected] and my password. I dropped the “@localhost”, which I had tried prior to the reboot, off the user name and only used “root” and the password. And up came the phpmyadmin home page. BTW, I never was able to login using “admin”

    one thing I did figure out was, to verify if you are using the correct root password, you can re-issue the cmd:
    “sudo mysql_secure_installation”.
    If you just hit ENTER, you will get an error if the root password has been set somehow.
    You can then type the password which you “think” is the correct one, if it is, the script continues and you can ^C’d out of it.
    then I rebooted, tried to log

    Reply
  7. Best thing about a raspberry pi is you can do this tutorial over and over again :). I almost have this memorized. Thank you Ed for your work you put into this. I have become a little big less stressed in the shell!

    Reply
  8. Very good tutorial. Successful outcome. Previously i have found this install a long process. But you accurately specified ability level in the prerequisites which I am now familiar with.

    In the I have fallen foul at the password phase when installing MYSQL. I have added extra notes to go with yours in my note book:
    You wrote: “at the New password: prompt, and press Enter.”
    I Wrote” (Important: Plan ahead, Practice write User name and password pair before entering, YOU ONLY ONE GO AT TYPING THIS PASSWORD – DOES NOT ASK FOR A RETYPE, SO BE SURE WHEN PRESSING KEYS)

    Reply
  9. I’m lost, tried everything I could think of, searched the web and still have an issue 🙁
    In my browser window I see this;
    Index of /
    [ICO] Name Last modified Size Description
    [ ] esp-data.php 2021-04-12 16:04 2.3K
    [DIR] phpmyadmin/ 2017-01-23 13:20 –
    [ ] post-esp-data.php 2021-04-11 14:11 2.1K
    Apache/2.4.38 (Raspbian) Server at 192.168.1.86 Port 80

    Click on phpmyadmin, enter username (admin) and password… loads with no problem

    Click on esp-data.php and get this: Connection has failed: Access denied for user ‘admin’@’localhost’ (using password: YES)

    Click on post-esp-data.php and get this: No data posted with HTTP POST.

    Running an ESP8266, serial window getting this: httpRequestData: api_key=tPmAT5Ab3j7F9&sensor=BME280&location=Office&value1=25.76&value2=56.35&value3=1014.36
    HTTP Response code: 200

    Where did the wheels come off the bus?

    Reply
  10. Everything worked exactly like stated in the tutorial, even the errors, until “Reload your web page (http://192.168._._/phpmyadmin), your should see the login page for phpMyAdmin web interface”. But at that point I didn’t get the phpMyAdmin web interface; instead yet another I got another 404 Not Found page.

    Something’s broken. I have no idea at the moment.

    Reply

Leave a Reply to Jack Maple Cancel reply

Download our Free eBooks and Resources

Get instant access to our FREE eBooks, Resources, and Exclusive Electronics Projects by entering your email address below.