LAMP Installation On Ubuntu

The acronym LAMP refers to a set of free software programs commonly used together to run dynamic Web sites or servers Linux, the operating system; Apache, the Web server; MySQL, the database management system (or database server) and Perl, PHP, and/or Python, scripting languages.

This tutorial is how to install LAMP on Ubuntu Desktop.

Linux

Here are several steps to install Ubuntu Linux Desktop if you have not already done so.

First download and burn your own installation CD file from the Ubuntu Linux site or order a free CD from Shipit - Free CDs.
Second, try out your new Ubuntu Linux without changing anything on your computer by booting the installation CD. This is a great way to test compatibility with your computer.
Third, install Ubuntu Linux permanently on your computer by double-clicking the install icon on your temporary desktop.
1. Download the Ubuntu Linux Desktop ISO CD image from the Ubuntu Linux site.
2. Burn a bootable CD from the ISO CD image.
3. Boot the CD on the target machine. Make sure the network is connected. If all is successful, Ubuntu Linux will start up in a fully functional friendly desktop environment. Experiment for a while if you like.
4. Double-click on the installer icon on the desktop to permanently install Linux.
5. Enter Name, Username, Password, and Time Zone. Set the clock if necessary. Choose automatic partition and format to erase the previous operating system.
6. WARNING - This will wipe out everything on the target machine hard drive.
7. Wait.
8. Restart.
9. Remove the CD to prevent starting over.
10. Type Enter to boot.
11. Login.

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

Insert this following line into testphp.php file.

<?php phpinfo(); ?>

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

sudo rm /var/www/testphp.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 newpassword
mysqladmin -h root@local-machine-name -u root -p password newpassword
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
Applications -> System Tools -> 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

Well done!

Share and Enjoy:

These icons link to social bookmarking sites where readers can share and discover new web pages.

December 30th, 2006 36 Comments Linux, Tutorial, Ubuntu

36 Responses to “LAMP Installation On Ubuntu”

Feed for this Entry Trackback Address

1 Alanlai on Jan 2nd, 2007 said:

Hi, i have a problem regarding this 2 command

mysqladmin -u root password newpassword
mysqladmin -h root@local-machine-name -u root -p password newpassword

when you mean “password newpassword”

do u want me to type that into my console as is??
or should i change password to my PASSWORD e.g.”apple”

and newpassword to something else?!!?

and for local-machine-name can i type my ip like “192.168.2.5″ ?

thanks for this easy to follow tutorial

anyways, I interpreted you to mean type password as is, and in place for newpassword, we put in our own password, our choice.

so what i did was

mysqladmin -u root password apple
mysqladmin -h root@192.168.2.5 -u root -p password apple

after the 2nd command, i was prompt to enter a password. Which i inputted apple.

However, i got the error of
“mysqladmin: connect to server at ‘root@klalaiold-desktop’ failed
error: ‘Unknown MySQL server host ‘root@klalaiold-desktop’ (1)’
Check that mysqld is running on root@klalaiold-desktop and that the port is 3306.
You can check this by doing ‘telnet root@klalaiold-desktop 3306′
”

for your info,,

“root@klalaiold-desktop:/etc# netstat -tap | grep sql
tcp 0 0 localhost:mysql *:* LISTEN 7648/mysqld ”

Thanks for this great tutorial
2 AlanLai on Jan 2nd, 2007 said:

moreover, oh the 2nd time running the following command, i get the following error

root@klalaiold-desktop:/home/klalaiold# mysqladmin -u root password apple
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@'localhost’ (using password: NO)’
root@klalaiold-desktop:/home/klalaiold# mysqladmin -h root@klalaiold-desktop -p password laiking1
Enter password:
mysqladmin: connect to server at ‘root@klalaiold-desktop’ failed
error: ‘Unknown MySQL server host ‘root@klalaiold-desktop’ (1)’
Check that mysqld is running on root@klalaiold-desktop and that the port is 3306.
You can check this by doing ‘telnet root@klalaiold-desktop 3306′
root@klalaiold-desktop:/home/klalaiold# telnet root@klalaiold-desktop 3306
telnet: could not resolve root@klalaiold-desktop/3306: Name or service not known
root@klalaiold-desktop:/home/klalaiold# netstat -tap | grep sql
tcp 0 0 *:mysql *:* LISTEN 4182/mysqld
3 Speediii on Jan 7th, 2007 said:

Mysql Administrator also hangs when you click on “User Administration.

I fixed this by adding the following line to /etc/environment

DEBUG_DONT_SPAWN_FETCHES=1
4 hg-203 on Jan 7th, 2007 said:

heads up, if your installing on a vanilla Ubuntu install make sure you have your repositories set up to grab the community maintained repositories, if not you probably wont be able to install the mysql-admin package
5 JASON on Jan 11th, 2007 said:

Yea, Mysql Administrator is hanging for me as well.

I made the DEBUG_DONT_SPAWN_FETCHES=1 adjustment but it is still hanging when I click on User Administration.

Anyone else?
6 Jason on Jan 11th, 2007 said:

Hrm, this was helpfull:
https://launchpad.net/ubuntu/+source/mysql-admin/+bug/29802

Best,
Jason
7 Alina Ma?at on Jan 13th, 2007 said:

I think these blog is really useful for new comers and Excellent resource list.
8 supriyadisw on Jan 14th, 2007 said:

AlanLai,

Let’s try to solve this

mysqladmin -h root@local-machine-name -u root -p password newpassword

You can try this:

mysqladmin -h localhost -u root -p password apple

or you can remove -h attribute:

mysqladmin -u root -p password apple
9 William on Jan 23rd, 2007 said:

So far, so good. Everything seems to be in order, so it’s time to push on and install WordPress. Many thanks for this excellent tutorial.
10 fwiffo on Feb 20th, 2007 said:

Installing mysql also forced installing postfix. Installing config needs configuring it with debconf. I had no idea how or why to do this, as I don’t need a mail server, need I? It would have been nice, if you had mention it or given some more info about it. Otherwise, thanks for the nice guide on installing lamp.
11 fwiffo on Feb 20th, 2007 said:

Typo: of course, on the second sentence I mean “Installing postfix” and not “Installing config”. Sorry.
12 Matt on Feb 26th, 2007 said:

As a security precaution, I would advise against setting mysql to listen to the entire internet, instead, just make sure that all your PHP scripts reference the server as “localhost” or “127.0.0.1″ and it should work fine.

Cheers,

Matt
13 rrutia on Feb 27th, 2007 said:

This procedure is to do LAMP install. Thanks..

Does anybody know how to create a database after the installation is complete?
14 Henry on Apr 12th, 2007 said:

I am a Windows pro, Webmaster pro, and total Linux n00b.

May I suggest that you also include instructions on how to modify apt-get to point to universe (and subsequently, to apt-get update)? In my installation, your instructions didn’t work because phpmyadmin and mysql-admin packages were not available.

Took me a good half hour to figure out the whole universe thing.

Thanks for the instructions, though.
15 dearblues on Apr 12th, 2007 said:

why did i get did msg

mysqladmin: connect to server at ‘localhost’ failed
error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
16 dearblues on Apr 12th, 2007 said:

and also. when i try to change to password again. i get this msg.

one more thing. how can i delete all the installation and do one more clean installation.
17 George Nagy on May 8th, 2007 said:

To Create a Database:

The easy way is through PHP MyAdmin, a web based MySQL front-end interface (and one of the packages installed in this tutorial.
http://localhost/phpmyadmin/

Log in with the root mysql account you created above. About half way down on the right side frame is a form for creating a new database.

———————–
PS: Cool tutorial. I agree about a need to explain (or at least mention) the postfix config as it threw me too.
18 Oscar on Sep 12th, 2007 said:

Great tutorial. I had tried using XAMPP earlier but encountered some problems and I was convinced that XAMPP would be en easier choice. I was looking for the XAMPP instructions again and fell into this page (thank God). I thought what the heck and followed the instructions step by step. Everything worked fine exept installing phpmyadmin. I installed it using the same command used in this tutorial but after installing everything else. It works fine.
19 Doug on Nov 15th, 2007 said:

Thanks for this gr8 LAMP guide. Got my Ubuntu LAMP shining brightly, for some home work over the weekend.

Right back 2 work.

Thanks again for posting this.
20 Kunst on Jan 10th, 2008 said:

There are many useful informations in this article. Thanks and greetings from Thuringia!
21 Ken on Jan 15th, 2008 said:

Two small nits to pick:

- Under MySQL Administrator, to start MySQL Administrator it is “Applications -> Programming -> MySQL Administrator”, not “Applications -> System Tools -> MySQL Administrator” - “System Tools” is wrong

- Under MySQL for Apache HTTP Server, you need ADD “extension=mysql.so” it is not included but commented out,a s your tutorial says.

Aside from the above nits, nice tutorial - off to install WOrdPress now (see you there)…
22 supriyadisw on Jan 16th, 2008 said:

William: Thanks

fwiffo: No problem

Matt: Thanks for ur suggestion

rrutia: You can run phpmyadmin or using command line to create database.

Henry: You can edit /etc/apt/source.list and add universe repository

dearblues: make sure your mysal is running by type sudo /etc/init.d/mysql start

To uninstall mysql type this command
sudo apt-get remove libapache2-mod-auth-mysql php5-mysql phpmyadmin

George Nagy: Thanks for your suggestion

Oscar: great

Doug: Thanks

Kunst: Greeting from Indonesia

Ken: Thanks. Perhaps I will check for the version of Ubuntu

Thanks a bunch…
23 Fensterfolie on Apr 9th, 2008 said:

Very good article, thanks for sharing
24 Bravo Web on Apr 18th, 2008 said:

Hi - I’m getting this but that disc is long gone. Any workarounds?

Media change: please insert the disc labeled
‘Ubuntu-Server 6.10 _Edgy Eft_ - Release i386 (20061025.1)’
in the drive ‘/cdrom/’ and press enter

Thanks!

Admin
25 crashnburn007 on Apr 20th, 2008 said:

please note inorder to get phpmyadmin working I had to open /etc/apache2/apache2.conf and add the line…
Include /etc/phpmyadmin/apache.conf
then restart apache
sudo /etc/init.d/apache2 restart
26 ray on Apr 29th, 2008 said:

Hi,thaks for your tutorial
but i’m got some trouble,when i type :

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

and press enter,there an error issues

Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
php5-mysql: Depends: php5-common (= 5.2.3-1ubuntu6) but 5.2.3-1ubuntu6.3 is to be installed
E: Broken packages

How to solve this?
Thanks before
27 Urlaub on May 10th, 2008 said:

Thanks for the tutorial.
@ray: it works with me, maybe just a temporary bug?