Ubuntu 16.04 LAMP server tutorial with Apache 2.4, PHP 7 and MariaDB (instead of MySQL)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache 2 web server on an Ubuntu 16.04 (Xenial Xerus) server with PHP 7 (mod_php) and MySQL support. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is the perfect basis for CMS systems like Joomla, Wordpress or Drupal.

 

Preliminary Note

In this tutorial, I will use the hostname server1.example.com with the IP address 192.168.1.100. These settings might differ for you, so you have to replace them where appropriate.

I recommend to use a minimal Ubuntu server setup as basis for the tutorial, that can be a virtual- or root server image with an Ubuntu 16.04 minimal install from a web hosting company or you use our minimal server tutorial to install a server from scratch.

I'm running all the steps in this tutorial with root privileges, so make sure you're logged in as root:

sudo su

 

Installing MariaDB as MySQL replacement

We will install MariaDB instead of MySQL. MariaDB is a MySQL fork maintained by the original MySQL developer Monty Widenius. MariaDB is compatible with MySQL and provides interesting new features and speed improvements when compared to MySQL. Run the following command to install MariaDB-server and client:

apt-get -y install mariadb-server mariadb-client

Now we set a root password for MariaDB.

mysql_secure_installation

You will be asked these questions:

Enter current password for root (enter for none): <-- press enter
Set root password? [Y/n] <-- y
New password: <-- Enter the new MariaDB root password here
Re-enter new password: <-- Repeat the password
Remove anonymous users? [Y/n] <-- y
Disallow root login remotely? [Y/n] <-- y
Reload privilege tables now? [Y/n] <-- y

Test the login to MariaDB with the "mysql command"

mysql -u root -p

and enter the MariaDB root password that you've set above. The result should be similar to the screenshot below:

MariaDB Login on Ubuntu 16.04.

To leave the MariaDB shell, enter the command "quit" and press enter.

 

Install Apache 2.4

Apache 2 is available as an Ubuntu package, therefore we can install it like this:

apt-get -y install apache2

Now direct your browser to http://192.168.1.100, and you should see the Apache2 default page (It works!):

The document root of the apache default vhost is /var/www/html on Ubuntu and the main configuration file is /etc/apache2/apache2.conf. The configuration system is fully documented in /usr/share/doc/apache2/README.Debian.gz.

 

Install PHP 7

We can install PHP 7 and the Apache PHP module as follows:

apt-get -y install php7.0 libapache2-mod-php7.0

Then restart Apache:

systemctl restart apache2

Test PHP and get details about your PHP installation

The document root of the default web site is /var/www/html. We will now create a small PHP file (info.php) in that directory and call it in a browser. The file will display lots of useful details about our PHP installation, such as the installed PHP version.

nano /var/www/html/info.php

<?php
phpinfo();
?>

Then change the owner of the info.php file to the www-data user and group.

chown www-data:www-data /var/www/html/info.php

Now we call that file in a browser (e.g. http://192.168.1.100/info.php):

PHPINFO output from PHP 7.

As you see, PHP 7.0 is working, and it's working through the Apache 2.0 Handler, as shown in the Server API line. If you scroll further down, you will see all modules that are already enabled in PHP5. MySQL is not listed there which means we don't have MySQL / MariaDB support in PHP yet.

 

Get MySQL / MariaDB support in PHP

To get MySQL support in PHP, we can install the php7.0-mysql package. It's a good idea to install some other PHP modules as well as you might need them for your applications. You can search for available PHP modules like this:

apt-cache search php7.0

Pick the ones you need and install them like this:

apt-get -y install php7.0-mysql php7.0-curl php7.0-gd php7.0-intl php-pear php-imagick php7.0-imap php7.0-mcrypt php-memcache  php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xmlrpc php7.0-xsl php7.0-mbstring php-gettext

Now restart Apache2:

systemctl restart apache2

PHP with MySQL / MariaDB support.

PHP 7 has now MySQL / MariaDB support as shown in phpinfo() above.

Install the APCu PHP cache to speed up PHP

APCu is a free PHP opcode cacher for caching and optimizing PHP intermediate code. It is strongly recommended to have an Opcache installed to speed up your PHP page.

APCu can be installed as follows:

apt-get -y install php-apcu

Now restart Apache:

systemctl restart apache2

Now reload http://192.168.1.100/info.php in your browser and scroll down to the modules section again. You should now find lots of new modules there:

APCu installed in PHP.

Please don't forget to delete the info.php file when you don't need it anymore as it provides sensitive details of your server. Run the following command to delete the file.

rm -f /var/www/html/info.php

Enable the SSL website in apache

SSL/ TLS is a security layer to encrypt the connection between the web browser and your server. Execute the following commands on your server to enable https:// support. Run:

a2enmod ssl
a2ensite default-ssl

which enables the ssl module and adds a symlink in the /etc/apache2/sites-enabled folder to the file /etc/apache2/sites-available/default-ssl.conf to include it into the active apache configuration. Then restart apache to enable the new configuration:

systemctl restart apache2

Now test the SSL connection by opening https://192.168.1.100 in a web browser.

Accept SSL Warning in Firefox

You will receive an SSL warning as the SSL certificate of the server is a "self-signed" SSL certificate, this means that the browser does not trust this certificate by default and you have to accept the security warning first. After accepting the warning, you will see the apache default page.

Apache default page in https mode.

The closed "Green Lock" in front of the URL in the browser shows that the connection is encrypted. To get rid of the SSL warning, replace the self-signed SSL certificate /etc/ssl/certs/ssl-cert-snakeoil.pem with an officially signed SSL certificate from an SSL Authority.

Install phpMyAdmin

phpMyAdmin is a web interface through which you can manage your MySQL databases. It's a good idea to install it:

apt-get -y install phpmyadmin

You will see the following questions:

Web server to configure automatically: <-- Select the option: apache2
Configure database for phpmyadmin with dbconfig-common? <-- Yes
MySQL application password for phpmyadmin: <-- Press enter, apt will create a random password automatically.

MariaDB enables a plugin called "unix_socket" for the root user by default, this plugin prevents that the root user can log in to PHPMyAdmin and that TCP connections to MySQL are working for the root user. Therefore, I'll deactivate that plugin with the following command:

echo "update user set plugin='' where User='root'; flush privileges;" | mysql -u root -p mysql

Enter the MariaDB root password, when requested by the mysql command.

Afterward, you can access phpMyAdmin under http://192.168.1.100/phpmyadmin/:

Login to phpmyadmin

PHPMyAdmin 

Share this page:

92 Comment(s)

Add comment

Comments

From: GainS

Thank you so much. Works perfectly.

From: J

Nice work, complete and worked perfectly first time.

From: Jeff Beam

excellent work thanks

From: Allen

WWWonderfuull!!!! :-)

From: christ noel

hello thanks for your tuto its works without problems thanks for the time spent by writting it its help someone like me

From: Tuan Anh Ha

Thank you very much! Vielen Dank für Ihre Hilfe!  

From: J.L. Barbry

Thank you to you for this tutorial which is very easy to use.Unfortunately, I get an error in the last step, after the installation of phpMyAdmin:The requested URL /phpmyadmin/ was not found on this server.

The same error with 127.0.1/phpmyadmin or localhost/phpmyadmin.

I tried 3 times to uninstall and reinstall without success.Pity that Ubuntu does not offer a LAMP package !

Best regards

From: till

Try to run:

 

dpkg-reconfigure phpmyadmin

 

and ensure that you select apache2 as config option. If no webserver config option is selected during phpmyadmin installation, then the alias to accessphpmyadmin does not get added to the apache config.

From: Gareth

Hi

You probably missed the fact that you need to put a mark in the selection of apache2 in the config. It definitely looks like it's selected it when the red box is in the selection thing, but unless you press space it won't mark it as selected and it won't configure it it for apache. Hope that makes sense?!

Cheers

Gareth

From: Bob W

Followed the instructions with 16_04 and everything worked great up to phpMyAdmin.

I get the message:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using         ? password: NO)

Uninstalled and tried again.

Still at a loss????

Other Ubuntu forum posts were for password: YES.

What should I check to solve this?

From: Daniel Whitney

I encountered the same issue, did you find a solution?

From: Adjustinthings

Also having this issue!

From: sruj

try this http://askubuntu.com/a/763359

From: abhijeet

Use this 

dpkg-reconfigure phpmyadmin

This is used for reconfiguring phpmyadmin, while reconfiguring  it will ask you for a username and password. This will be used for logging in.

From: Seb

Try this. Fixed my issue in Ubuntu 16.10

http://askubuntu.com/questions/387062/how-to-solve-the-phpmyadmin-not-found-issue-after-upgrading-php-and-apache

From: DSmidge

Installing APCu is not necessary.

As it states on http://php.net/manual/en/intro.apcu.php: "APCu is APC stripped of opcode caching."

From: till

And that's exactly why we install APCu. For Opcode caching, we have already "Opcache" installed. But many software relies on the APC specific caching functions e.g. as a page cache and that's why we install APCu on top of Opcache, it adds the APC functions to PHP when Opcache is installed.

From: Simon Zalar

But in the article you wrote: "APCu is a free PHP opcode cacher for caching and optimizing PHP intermediate code. It is strongly recommended to have an Opcache installed to speed up your PHP page."

Which IMHO is not true. 

From: till

Did you ever benchmark PHP without an opcode cache (and yes, the Opcache extension in PHP 7 is also an opcode cache, so disable it when you want to test without an opcache) with a PHP version that runs an Opcode cache? And if yes, did you do that in real life scenarios like a WordPress website with caching plugins enabled? I did that for different PHP versions and that's why I recommend to install it. But you don't have to believe me of course, leave it out, your server will work without it. As a side note, many caching plugins in websites recognize APC and use its specific functions as internal cache, APCu emulates this for newer PHP versions, so just installing opcache without APCu will not make these options available for your site.

From: FranzS

Thank you for the Tutorial! It is very awesome.

On Unbuntu 16.04 i get a failure message in /var/syslog if i take a closer look.

It seems that setting a secure password for root user will do create problems with mysqlcheck because the password ist not updated in /etc/mysql/debian.cnf

For details see:

http://askubuntu.com/questions/772785/16-04-mariadb-error-in-syslog-mysqlcheck

From: Clark

Thanks a lot spent hours trying to get my lamp running. I used mysql though :)

From: tom

Thanks, this helped getting my new dev server up and running :)

From: steve

I wonder if you can help. I have followed all you tutorial which is well presented. but I cannot access phpmyadmin. I also did not know where to add the last line in you tutorial about unix_socket.

i have reinstalled the phpmyadmin and ensure apache2 is the server to use. i have checked and included the following line to apache2.conf

Include /etc/phpmyadmin/apache.conf

but still no access. any help would be great thankyou

From: Dante Camacho

Thank you so much for this pice of cake!

From: Stephanie

Hi

I managed to install everything fine butwhen I tried to run info.php I got the following message:

Forbidden

You don't have permission to access / on this server.

Apache/2.4.18 (Ubuntu) Server at localhost Port 80 Here are the document root file permissions:[email protected]:/var/www/html# ls -ltotal 16-rw-r--r-- 1 root     root     11321 May 20 00:56 index.html-rw-r--r-- 1 www-data www-data    35 May 20 01:55 [email protected]:/var/www/html#

 

From: Andriy

Amazing! Thank you for this great tutorial.

From: stefano giacomini

excellent work thanks!

From: Bibot

It says "ERROR 1046(3D000) at line 1: No database selected"

From: otis

Not Found

The requested URL /phpmyadmin was not found on this server.

Apache/2.4.18 (Ubuntu) Server at localhost Port 80  i have a problem to access on phpmyadmin i don't know why, i've followed perfectly this tuto, please could you help me?

From: till

You missed to enable phpmyadmin for apache (as described in the tutorail). You can redo the step by running:

 

dpkg-reconfigure phpmyadmin

 

then ensure that apache 2 is selected, there must show a cross for the apache option which gets enabled with the whitespace key of your keyboard. If no cross is shown there, then apache is not active for phpmyadmin and you wont be able to reach it then!

From: Ed

Hi,

 

Thanks, but Apache 2.4 is valuable with the event module enabled, and ISPConfig won't work with it - it insists on using morker right?  Can't you change this so we can use the much better event, please? Thanks

From: till

ISPConfig does not depend on a specific apache mode, you just will not be able to use the mod_php mode in ispconfig in worker mode.

From: Carlos Guena

Thank you for this great tutorial! Everything works perfect but phpmyadmin. I got:

"Not FoundThe requested URL /phpmyadmin was not found on this server.Apache/2.4.18 (Ubuntu) Server at 104.154.46.68 Port 80"

Could you help me? Any idea? Thanks.

 

From: Carlos Guena

 Solved "The requested URL /phpmyadmin/ was not found on this server." :

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

sudo service apache2 restart

From: edmar

Você é o melhor perfeito funcionando redondo.

Obrigado

From: Luis

At last, thanks...

From: Rafael

Muitissimo obrigado.

thx!!!

From: Wolfgang Bartsch

Vielen Dank für dieses Howto. Es hat mir sehr geholfen, da ich wirklich Probleme hatte phpmyadmin zum laufen zu kriegen. Aber nun ist wieder alles so wie sein soll

 

Many thanks

wolfgang

From: Wolfgang Bartsch

Thank you this howto is perfect. I used it on Linux Mint 18

greets wolfgang

 

From: carlos moreno

 

muchas gracias después de estar buscando como un loco y no poder andar el phpmyadmin, parece ser que por este método no da problemas.

 

solo quedaría para terminar tu tutorial agregar al final

 

/etc/apache2/apache2.conf agregando: Include /etc/phpmyadmin/apache.conf

 

para que funcione phpmyadmin

 

y nada mas. muy buen tutorial

 

 

From: Paul

Excellent guide, thank you very much!

Just one remark, with a local install on Xubuntu the address 192.168.1.100 does not work, but http://localhost does (and consequently localhost/info.php and localhost/phpmyadmin)

Suggestion: tell the user that the inlog name for the phpmyadmin page is root and the password is the one for MariaDB. That was not clear to me at first sight, because we just installed several software packages!

Thanks again for your work,

Paul.

From: Jrarr

Thanks for this comment Paul, it didn't work on 16.04 until I typed this. Just not sure how to interpret your fix for this.

From: James

Whole installation went fine except as others I had issues with the phpmyadmin install: The requested URL /phpmyadmin/ was not found on this server.

It was the firewall with me the command to fix was sudo ufw allow in "Apache Full"

From: Sven

Supppper!

From: Michael Cooper

Hello Guys,

       Everything works except the https: (SSL) not sure why I followed it to the letter, I will be troubleshooting until I figure it out.

 

Thanks,

From: ladjailia

Thanks

From: Mikiya

Nice tutorial, thanks ^_^

From: AdminOnmint

 Thank you mate for this post.... I upgraded my system to Mint 18 and had some buggs. after reviewing this post, it has solved the issue I had.

From: Larry Robinson

I have followed your instruction, and rechecked all, but can not get any responce for info.php...All I get is a blank page...I have the ports 80 and 443 open in firewalld...Hope you can help.

From: zcong

thanks very mych , it makes work easily!!

From: Marco

Impeccabile, installazione perfetta, semplice e funzionale

Grazie per il VS ottimo lavoro

From: Benedict Poppe

Very nice article, works perfectly :)

From: Pablo Menezes

Perfect Tutorial , Thanks!!!

From: DanielS

Flawless Victory!

From: Ram

Thanks so much.  This has helped me a lot!

From: Lennon Castro

It works fine!

From: William Vasquez

Excelente post. todo funciona casi a la perfeccion, me gusto la colaboracion colocada, me falta hace multiple dominios para diferentes hosting hay ire dandome golpes de pecho.!

From: cong nguyen

wow. it's work ! thanks so much

From: Juan carlos

muy valiosa la información, gracias por este aporte

From: vic

Thank you!!

From: natzdc

Tnx for a very detailed STEPS: just need help

: I got everything done, but I just got some few errors:

1. [email protected]:/home/hive# a2ensite dafault-ssl    ERROR: Site dafault-ssl does not exist!

- https not working

2.  "Connection for controluser as defined in your configuration failed."

 

From: Sidi4

This is really gtate tutorial - the that you can folow and it works.

Even I had an issues with phpmyadmin, but was able quicly to fix it with

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin.conf sudo service apache2 reload

If I may request to make a tutoreal or just explain (anyone) how to "Install PHP 7 with zts."

I'm really having a hard time to find any information about it.

I need ZTS for "pecl install pthreads".

 

From: Sidi4

This is really gtate tutorial - the that you can folow and it works.

Even I had an issues with phpmyadmin, but was able quicly to fix it with

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin.conf sudo service apache2 reload

If I may request to make a tutoreal or just explain (anyone) how to "Install PHP 7 with zts."

I'm really having a hard time to find any information about it.

I need ZTS for "pecl install pthreads".

 

From: Sidi4

This is really great tutorial - the that you can follow and it works.

Even I had an issue with phpmyadmin, but was able quickly to fix it with

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin.conf sudo service apache2 reload

If I may request to make a tutoreal or just explain (anyone) how to "Install PHP 7 with zts."

I'm really having a hard time to find any information about it.

I need ZTS for "pecl install pthreads".

 

From: shijin

Wonderfull Document... helped me a lot....

Only one issue faced: phpmyadmin is not working after I installed it . I did following and its woked like a charm!!!..

vi  /etc/apache2/apache2.conf

Then add the following line to the end of the file.

Include /etc/phpmyadmin/apache.conf

Then restart apache

/etc/init.d/apache2 restart

 

 

 

From: erama

It is possible add SpeedPage module to this configuration, and this is convenient?Thank you so much!. 

From: kevin

so where do i find the bind-address so I can let my remote server connect to the database? can this be done in phpmyadmin?  

From: peter

Excellent tutorial. Did the install in less than 10 mins.

Danke

From: Per Löwgren

Excellent! Thanks!

From: Gabor

Thank you for your great article, helped me to a lot. Now I have a fast development computer.

In my case http://localhost worked instead of IP address, and I also get an 404 Error on phpmyadmin but as Carlos Guena suggested, this three line of command solved the problem:

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.confln -s /usr/share/phpmyadmin /var/www/html/phpmyadminservice apache2 restart

 

From: Renato Leal

Thanks! You are man!

From: netto

OMG! Perfectly Documented! Thanks a lot!

From: Eric Wood

I receive an error message when trying to access 192.168.0.230/php.info, the browser will not access the page. What am I doing wrong? 

From: Eric W

I am having issues accessing php.info and the echo command involving disabling the unix_socket. It is showing an issue with the word priviledges.

From: John Perczyk

Absolutely perfect and just what I was looking for.

Much easier than most other websites that take you through convulted twists and turns to get this to work.

From: Eric W

Still having issues with php.info but figured out unix_socket. Whenever I try to access phpmyadmin I get nothing but a bunch of text. Why does it appear I'm getting code and not phpmyadmin?

 

From: Raimehn Roger

It Works perfectly thanks..

From: Chato

Excellent tutorial bro, It works!

From: Yudi Andela

Thanks for this excellent article.

And it works very well

From: JuanGuillermo

Thank you so much. Works perfectly....

Buen tutorial funciona perfectamente ... muchas gracias

From: GreyWolf

Great tutorial, thank you. I did get stuck trying to log in to phpMyAdmin however the comment from till was spot on. It might be worth editing the guide to ensure a password is entered and not randomly generated or add a section for adding a mysql user to avoid being locked out of mysql completely.

From: charlie

Thank you very much , awesome tutorial great job

From: DanB

Just a not that these directions also work well on 16-10!

From: jay

The title says that this tutorial is for 16.04 and not for Ubuntu 16.10. But I'm sure that howtoforge will post a tutorial for 16.10 soon as usual. For servers it is better to use a LTS version like Ubuntu 16.04 anyway.

From: Kasalop

Hi,

the new package names are:

php7.0-memcached instead of php-memcache (btw: the d is missing in the statement above)

php7.0-imagick instead of php-imagick

 

thanks for this very well tutorial!

regards, Kasalop

From: Jan

Great tutorial, if someone would make a script for this, it would be amazing! And just a note about the last part of the tutorial - phpmyadmin. If you cant reach the phpmyadmin after you've done all the steps,  then you should add Include /etc/phpmyadmin/apache.conf to  the /etc/apache2/apache2.conf file and restart the service.

From: John

Thank you so much. Clearly explained.

From: Yon

I had so many issues, untill I came accross this, worked flawlessly. Thank you for making the world a better place!

From: avanerie

I have followed your instructions, but after:

> Now we set a root password for MariaDB.

 

mysql_secure_installation

 

> You will be asked these questions:

> Enter current password for root (enter for none): <-- press enter

I can't set a root password. After pressing enter it says:

>  Access denied for user 'root'@'localhost' (using password: NO)

So I can't make changes.

Can anyone help?

 

From: Jorge

Thank you, all steps worked perfectly.

From: Yann Lehmann

Thank you so much for this tutorial.

I have been using it on several servers, and it worked every time.

From: Alain Bex

Great manual.

One of the few manuals where everything works as explained.And where the explanations is complete! Fantastic job.

1 improvement : to lging in phpadmin : to use the username root