{"id":12943,"date":"2019-03-29T03:41:42","date_gmt":"2019-03-29T03:41:42","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=12943"},"modified":"2019-03-29T03:41:42","modified_gmt":"2019-03-29T03:41:42","slug":"how-to-install-lamp-stack-with-phpmyadmin-in-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/03\/29\/how-to-install-lamp-stack-with-phpmyadmin-in-ubuntu-18-04\/","title":{"rendered":"How to Install LAMP Stack with PhpMyAdmin in Ubuntu 18.04"},"content":{"rendered":"

A\u00a0LAMP<\/strong>\u00a0stack is composed of packages such as\u00a0Apache<\/strong>,\u00a0MySQL\/MariaDB<\/strong>\u00a0and\u00a0PHP<\/strong>\u00a0installed on a Linux system environment for hosting websites and apps.<\/p>\n

Read Also<\/strong>:\u00a0Install Apache, MariaDB, PHP and PhpMyAdmin in Ubuntu 18.04<\/a><\/p>\n

PhpMyAdmin<\/strong>\u00a0is a free, open source, well known, fully-featured, and intuitive web-based frontend for administering\u00a0MySQL<\/strong>\u00a0and\u00a0MariaDB<\/strong>\u00a0database. It supports various database operations, and has many features that allow you to easily manage your databases from a web interface; such as importing and exporting data in various formats, generating complex and useful queries using Query-by-example (QBE), administering multiple servers, and much more.<\/p>\n

Requirements:<\/h4>\n
    \n
  1. Minimal Ubuntu 18.04 server Installation.<\/li>\n
  2. Access to server via SSH (if you don\u2019t have direct access).<\/li>\n
  3. Root user privileges or use\u00a0sudo command<\/a>\u00a0to run all commands.<\/li>\n<\/ol>\n

    In this article, we will explain how to install\u00a0LAMP<\/strong>\u00a0stack with\u00a0PhpMyAdmin<\/strong>\u00a0in\u00a0Ubuntu 18.04<\/strong>.<\/p>\n

    Step 1: Install Apache Web Server on Ubuntu 18.04<\/h3>\n

    1.<\/strong>\u00a0First start by updating your software packages and then install\u00a0Apache<\/strong>\u00a0web server using following commands.<\/p>\n

    $ sudo apt update\r\n$ sudo apt install apache2\r\n<\/pre>\n
    2.<\/strong>\u00a0After the installation process is complete, the apache service should start automatically and will be enabled to start at system boot time, you can check if it\u2019s up and running using following command.<\/p>\n
    $ sudo systemctl status apache2\r\n<\/pre>\n
    3.<\/strong>\u00a0If you have a system firewall enabled and running, you need to open the ports\u00a080<\/strong>\u00a0and\u00a0443<\/strong>\u00a0to allow client connection requests to apache web server via\u00a0HTTP<\/strong>\u00a0and\u00a0HTTPS<\/strong>\u00a0respectively, then reload the firewall settings as shown.<\/p>\n
    $ sudo ufw allow 80\/tcp\r\n$ sudo ufw allow 443\/tcp\r\n$ sudo ufw reload\r\n<\/pre>\n
    4.<\/strong>\u00a0Now verify your Apache installation by testing default test page at the below URL from a web browser.<\/p>\n
    http:\/\/domain_name\/\r\nOR\r\nhttp:\/\/SERVER_IP\/\r\n<\/pre>\n
    If you see the apache default web page, it means your installation is working fine.<\/p>\n
    \n
    \"Check<\/a><\/p>\n
    Check Apache Web Page<\/p>\n<\/div>\n
    Step 2: Install MariaDB on Ubuntu 18.04<\/h3>\n
    5.<\/strong>\u00a0Now install\u00a0MariaDB<\/strong>, is a free, open source database management system forked from\u00a0MySQL<\/strong>\u00a0and it is a community developed project being led by the original developers of\u00a0MySQL<\/strong>.<\/p>\n
    $ sudo apt install mariadb-server mariadb-client\r\n<\/pre>\n
    6.<\/strong>\u00a0The\u00a0MariaDB<\/strong>\u00a0services should start automatically after installation, check its status to ensure that it is up and running.<\/p>\n
    $ sudo systemctl status mysql\r\n<\/pre>\n
    7.<\/strong>\u00a0The\u00a0MariaDB<\/strong>\u00a0installation is not secure by default, you need to execute a security script that comes with the package. You will be asked to set a\u00a0root password<\/strong>\u00a0to ensure that nobody can log into the MariaDB.<\/p>\n
    $ sudo mysql_secure_installation\r\n<\/pre>\n
    Once you execute the script, it will ask you to enter current password for root (enter for none<\/strong>):<\/p>\n
    Then enter\u00a0yes\/y<\/code>\u00a0to the following security questions:<\/p>\n