LAMP installation for Ubuntu

LAMP - Linux Apache Mysql Php

Apache

Install Apache

sudo apt-get install apache2
(Testing HTTP Server by open a web browser and enter http://localhost)

PHP

Install PHP5

sudo apt-get install php5 libapache2-mod-php5

Stop/Restart Apache

sudo /etc/init.d/apache2 restart

Test the installation

sudo gedit /var/www/testphp.php
(you can use vi or nano editor instead of gedit)

Insert this following line into test.php file.

Save this new file.
Open a web browser and enter http://localhost/test.php
Be sure to remove the file afterwards, as it may pose a security risk.

sudo rm /var/www/test.php

MySQL

Install MySQL Server

sudo apt-get install mysql-server

MySQL initially only allows connections from the localhost (127.0.0.1). We’ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Open the file /etc/mysql/my.cnf

gksudo gedit /etc/mysql/my.cnf

Find the line bind-address = 127.0.0.1 and comment it out then save the file.
MySQL comes with no root password as default. This is a huge security risk. You’ll need to set one. So that the local computer gets root access as well, you’ll need to set a password for that too. The local-machine-name is the name of the computer you’re working on.

mysqladmin -u root password yourpassword
mysqladmin -h root@local-machine-name -u root -p password yourpassword
sudo /etc/init.d/mysql restart

MySQL Administrator

Install MySQL Administrator

sudo apt-get install mysql-admin

Refresh Gnome Panel

killall gnome-panel

Run MySQL Administrator
(On ubuntu) Applications -> System Tools -> MySQL Administrator
(On Kubuntu) Applications -> Development -> MySQL Administrator

MySQL for Apache HTTP Server

sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

To get PHP to work with MySQL, open the php.ini file

gksudo gedit /etc/php5/apache2/php.ini

You’ll need to uncomment the “;extension=mysql.so” line so that it looks like this

extension=mysql.so

Restart Apache

sudo /etc/init.d/apache2 restart