LAMP

Linux Apache MySql Php

If you're developing websites, it's nice to be able to test your code in the privacy of your own computer rather that out in the public internet. In order to do that, you'll need to install a webserver on your development computer. LAMP (Linux, Apache, MySQL, php) is one of the most common web hosting platforms, so it's a perfect environment for you to build and test your website code. If you carefully follow these step by step instructions, you'll have your own LAMP setup, configured, and running in no time.

Install LAMP on Ubuntu

The Ubuntu developers have made it easy to install and configure the LAMP server packages with a single command. Simply open a terminal window and enter the following.

sudo apt-get install lamp-server^

No, that's not a typo. Please make sure to include the caret (^). The command will not work without it.

The apt package manager will show all the packages that need to be installed. Hit <Enter> to confirm that you want to install them.

You will then be prompted to change the password for the root user on the MySQL database.

Enter the password you want. You'll be prompted to enter it a second time to confirm.

After you confirm your password, apt will continue to install the rest of the packages.

Congratulations, your LAMP installation is now complete! That was the easy part, now you need to get a few things configured to make your system easy to work with.

Test Apache

Open a web browser and enter the address http://localhost/. You should see a web page that says "It Works!"

Test php

Now that you know Apache works, you'll want to test the php installation. You'll need to create a file in /var/www called testing.php. Open a terminal and enter:

sudo nano /var/www/testing.php

Enter the following line into the text editor, save the file and exit.

<?php phpinfo(); ?>

Next, restart Apache with the following terminal command:

sudo /etc/init.d/apache2 restart

Now go back to your web browser and enter the address http://localhost/testing.php/. You should see a page displaying version information for your php installation.

Configure MySQL

Since I'm installing LAMP for a web development environment, I want the MySQL database to be bound to the localhost IP address. This should be 127.0.0.1 for your system. You can verify it with this terminal command.

cat /etc/hosts | grep localhost

You'll now want to verify that the correct bind address is set up in MySQL's my.cnf file.

cat /etc/mysql/my.cnf | grep bind-address

You should see a line that looks like this:

bind-address = 127.0.0.1

If the IP address doesn't match the one for your system, you'll need to edit the my.cnf file to correct it.

Install phpMyAdmin

You don't need to install phpMyAdmin, but it's a much easier way to get in and adjust things in your MySQL database if you're not familiar with MySQL's commands. You can install phpMyAdmin from the command line with:

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

The installation will prompt you to select a web server for automatic configuration.

This is important! Use the space bar on your keyboard to select apache2. Make sure there's a * next to apache2 like the picture below and then hit <Enter>. (Click the picture to enlarge it and see what I'm talking about.)

The next screen will explain some information about database configuration. Hit the <Enter> key to move on.

Another screen will come up asking if you want to configure a new database called dbconfig-common. Since this is a fresh installation, use the <Tab> key to select Yes and hit <Enter>.

You'll be prompted next to enter the MySQL root password. Enter the MySQL root password that you created earlier, hit <Tab> to select Ok and hit <Enter>.

You'll then be prompted to enter a MySQL application password for phpmyadmin. You can hit <Enter> and a random password will be generated. I chose to use the same password that I used for the root MySQL password.

If you enter your own password, a password confirmation screen will come up. Confirm your password.

Your phpMyAdmin installation and configuration is now complete.

Testing phpMyAdmin

Open your web browser and enter the address http://localhost/phpmyadmin/. You should see a page like this.

You can log in with the username root and the root password that you created earlier.

Congratulations, you're now ready to start building your local website. If you're only working on one site you can put all of your files into /var/www. If you'll be working on multiple sites you may want to consider some additional Apache configuration to keep things neat and clean on you system.

--------------------------------------------------------------------------------------------------------------------------------------

Extra Step

To install phpMyAdmin, go to a Terminal window or command prompt and type this command:

sudo apt-get install phpmyadmin

This will download and install phpMyAdmin on your Ubuntu system. The phpMyAdmin package comes with quite a lot of dependencies, so the downloading and installation might take some time.

Once the package starts installing, it will ask you whether or not you want to use Apache or lighttpd for phpMyAdmin’s web server. Generally, unless you have a good reason to do otherwise, I’d recommend that you use Apache. (You can use the tab key to move the cursor while within the dialog box, if you get stuck.)

Next, the installer will ask if it can create and configure a database for phpMyAdmin using the dbconfig-common script. If you’re a first-time user, and don’t have advanced configuration needs, then use the tab key to select Yes and hit enter. The script will ask you for the password of your MySQL server’s root user. Enter the password, and the installer will continue.

The installer will then ask for a password for phpMyAdmin’s database user. Pick a password for the database user. Remember, as always, to set a strong password, with a mixture of uppercase letters, lowercase letters, numerals, and punctuation. You’ll then need to enter the password again.

Then,

1. Add the following line to the end of of file /etc/apache2/apache2.conf:

Include /etc/phpmyadmin/apache.conf

You might have to change the permissions of file

sudo chmod 664 apache.conf

2.Restart Apache by giving this command on the command line:

sudo /etc/init.d/apache2 restart

After that, the installer will wrap up and return you to the command line. If you installed it locally, you can then access your new phpMyAdmin installation by opening up a web browser on your Ubuntu system and navigating to this address:

http://127.0.0.1/phpmyadmin

Enter your MySQL root user and password, and you’ll have access to phpMyAdmin.

You can also access phpMyAdmin from a remote computer. For instance, if you installed phpMyAdmin on the machine with the IP address of 192.168.1.100, you would access it with this address:

http://192.168.1.100/phpmyadmin