x386.org: Debian and Ubuntu Documentation

|  Home  |  About  |  Contact  |  License  |  Privacy Policy  |

Copyright (C) 2020 - 2024 Exforge exforge@x386.org

This document is free text: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or any later version.

This document is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see .


LAMP Stack On Debian and Ubuntu

0. Specs

Digital Ocean

1. Install Packages

1.0. Update Repositories

sudo apt update

1.1. Install Apache

sudo apt install --yes apache2

1.2. Install MariaDB

sudo apt install --yes mariadb-server

1.3. Secure MariaDB

The following command makes some fine tunes regarding Mariadb security.

sudo mysql_secure_installation

You will be asked some questions.

Enter current password for root (enter for none):

There is no password yet, so press enter.

The next 2 questions

Switch to unix_socket authentication [Y/n]
Change the root password? [Y/n]

are about securing root account. In Ubuntu and Debian root account is already protected, so you can answer n.

For the next questions you can select default answers.

1.4. Install PHP, Mariadb and Apache dependencies

sudo apt install --yes php libapache2-mod-php php-mysql

1.5. Install other PHP dependencies

Depending on the PHP code, you may need some more PHP library packages.

For example, Wordpress needs the following packages:

sudo apt install --yes php-curl php-gd php-mbstring php-xml php-xmlrpc \
     php-soap php-intl php-zip

1.6. Restart Apache

sudo systemctl restart apache2

2. Test LAMP Stack

We'll create a test database, a table in that database, add some rows to the table on Mariadb. We will also create a test PHP file with the PHP code to retrieve the data from the database and display it as HTML.

2.1. DB Operations

Connect to Mariadb shell

sudo mariadb

Create mysampledb database, connect to it, create a table, fill the table, create a user with the access permission to that database and the table.

Run on Mariadb shell.

USE mysampledb;
CREATE TABLE Employees (Name char(15), Age int(3), Occupation char(15));
INSERT INTO Employees VALUES ('Joe Smith', '26', 'Ninja');
INSERT INTO Employees VALUES ('John Doe', '33', 'Sleeper');
INSERT INTO Employees VALUES ('Mariadb Server', '14', 'RDBM');
GRANT ALL ON mysampledb.* TO 'appuser'@'localhost' IDENTIFIED BY 'password';

2.2. Create Test PHP

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

Fill as below

   $mycon = new mysqli("localhost", "appuser", "password", "mysampledb");
   if ($mycon->connect_errno)
      echo "Connection Error";
   $mysql = "SELECT * FROM Employees";
   $result = ($mycon->query($mysql));
   $rows = [];
   if ($result->num_rows > 0)
        $rows = $result->fetch_all(MYSQLI_ASSOC);
<!DOCTYPE html>
               foreach($rows as $row)
                <td><?php echo $row['Name']; ?></td>
                <td><?php echo $row['Age']; ?></td>
                <td><?php echo $row['Occupation']; ?></td>
            <?php } ?>

2.3. Test it

Now, from your workstation's browser, load the page (replace srv with your server's IP or name: