As the first post of this site, I think this is the most appropriate topic. Lets go through installation process of LAMP(on Ubuntu 12.04), checking issue and then install phpmyadmin – the most popular database management script for MySql databases with Php.

A. Installation

On Ubuntu 12.04, its just a one line command-

sudo apt-get install lamp-server^

Setup process is easy to follow. You will be asked to set MySql username and password.

Some extra modules you may feel interest to install in your web server:

sudo apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-cgi

B. Issue?

While openning apache [command: service apache2 start or service apache2 restart ], if you get error like this:

apache2: Could not reliably determine the server’s fully qualified domain name, using for ServerName

then open the terminal and type

sudo gedit /etc/apache2/httpd.conf

### By default httpd.conf file will be blank. Now, simply add the following line to the file.

ServerName localhost

### Save the file and exit from gEdit. Finally restart the server.

sudo /etc/init.d/apache2 restart

C. phpmyadmin

phpmyadmin is one of the most popular database manaegment script to handle MySql databases. To install phpmyadmin run this command on your terminal:

sudo apt-get install phpmyadmin

While installing phpmyadmin, configuring database connection option will pop up. It is wise for beginner to go through the steps to configure phpmyadmin with mysql.

If you install it on your local server, phpmyadmin link should be http://[ localhost OR serverName ]/phpmyadmin in most cases. If you found your phpmyadmin link is not working, then simply check /etc/apache2/apache2.conf file, check the ‘include’ lines and add this line after those:

Include /etc/phpmyadmin/apache.conf

All should be working fine. Let me know if not.