Install Basic Setup Of Apache2 / PhpMyAdmin / MySql Server On Ubuntu 16.04 – Install Basic Setup Of LAMP

Hello Coders !! This article is about Install Basic Setup Of Apache2 / PhpMyAdmin / MySql Server On Ubuntu 16.04 – Install Basic Setup Of LAMP. This will helps you to start coding.

Step 1: Apache Installation

The initial step to start with

Apache is out there within Ubuntu’s default software package repositories. So now will install Apache2 using normal package management tools.

We will start by updating the local packages index.

Now, we are going to install the apache2 package by following below commands :

$ sudo apt-get update
$ sudo apt-get install apache2

After the installation process, Ubuntu 16.04 starts Apache. The web server should already be up and running.

We can check with the systemd init system to make sure the service is running by typing:

$ sudo systemctl status apache2
$ Output
● apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Fri 2017-05-19 18:30:10 UTC; 1h 5min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 4336 ExecStop=/etc/init.d/apache2 stop (code=exited, status=0/SUCCESS)
  Process: 4359 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCCESS)
    Tasks: 55
   Memory: 2.3M
      CPU: 4.094s
   CGroup: /system.slice/apache2.service
           ├─4374 /usr/sbin/apache2 -k start
           ├─4377 /usr/sbin/apache2 -k start
           └─4378 /usr/sbin/apache2 -k start

As we can see above, the service started running successfully. However, the best way to test this is to actually request a page from Apache using Domain name or IP, If we have configured it in local PC then domain must be [localhost] or Ip must be [127.1.1.1]

http://localhost Or http://127.1.1.1

We should see the default Ubuntu 16.04 Apache web page, which should look something like this:

Step 2: MySQL Installation

Database purpose

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It can be used for a relational database and SQL (Structured Query Language) to manage the data.

In a simple way we can follow the below steps and install it.

Now we will update the package index and install the Mysql-server package and then run the included security script.

$ sudo apt-get update
$ sudo apt-get install mysql-server

Now check MySQL service

$ systemctl status mysql.service
$ ● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: active (running) since Thu 2019-01-31 11:25:08 IST; 4h 26min ago
  Process: 1017 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=ex
  Process: 1005 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit
 Main PID: 1016 (mysqld)
   CGroup: /system.slice/mysql.service
           └─1016 /usr/sbin/mysqld

Jan 31 11:25:07 ashok systemd[1]: Starting MySQL Community Server...
Jan 31 11:25:08 ashok systemd[1]: Started MySQL Community Server.
lines 1-11/11 (END)

If MySQL is not running or giving any error then we can start it with below command

$ sudo systemctl start mysql.

Step 3: PhpMyAdmin Installation

This step is not necessary but this will be helpful if you set up this

To getting started, we will install phpMyAdmin from the Ubuntu repositories.

We can do this by updating our local package index and then using the apt packaging system to pull down the files and install them on our system:

$ sudo apt-get update
$ sudo apt-get install phpmyadmin php-mbstring php-gettext

This will ask us a few questions while configuring our installation correctly.

For the server selection, choose [apache2].

Select [yes] when asked whether to use dbconfig-common to set up the database

There will be on popup open for the administrator’s password

We will then be asked to choose and confirm a password for the phpMyAdmin application.

The installation process actually adds the phpMyAdmin Apache configuration file into the /etc/apache2/conf-enabled/ directory, where it is automatically read.

The only thing we need to do is explicitly enable the PHP mcrypt and mbstring extensions, which we can do by typing:

$ sudo phpenmod mcrypt
$ sudo phpenmod mbstring

After that, we need to restart Apache for our changes to be recognized:

$ sudo systemctl restart apache2

We must copy and follow below things too:

$ sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/conf-enabled/phpmyadmin.conf

Then open it:

$ sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf

Add a line after “DirectoryIndex index.php”:

AllowOverride All

#Example:
<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
AllowOverride All

Now we can access the web interface by visiting our server’s domain name or public IP address followed by /phpmyadmin:

https://localhost/phpmyadmin  OR https://127.1.1.1/phpmyadmin

We can now log into the interface using the root username and the administrative password we set up during the MySQL installation.

Great! Now we are done with Install Basic Setup Of Apache2 / PhpMyAdmin / MySql Server On Ubuntu 16.04 – Install Basic Setup Of LAMP.