STEP BY STEP INSTALL LAMP + PHPMYADMIN ON UBUNTU

set up a LAMP (Linux, Apache, MySQL, php), It’s useful if you want to set up a private web development environment. There is a plethora of Open Source applications written using the LAMP application stack. Some popular LAMP applications are Wiki's, Content Management Systems, and Management Software such as phpMyAdmin.

1. The Ubuntu developers have created a very easy way to install a LAMP server on an existing system, the command on terminal

sudo apt-get install lamp-server^

During installation of the LAMP server, an initial MySQL "root" user password is created. 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.

2. configure php.ini

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

find the line ;extension=msql.so

and then remove the sign ";"  so that it becomes like the following

extension=msql.so

then restart apache

/etc/init.d/apache2 restart

3. Install phpmyadmin

phpMyAdmin is a LAMP application specifically written for administering MySQL servers. Written in PHP, and accessed through a web browser, phpMyAdmin provides a graphical interface for database administration tasks. From a terminal prompt enter:

sudo apt-get install phpmyadmin

At the prompt choose which web server to be configured for phpMyAdmin. The rest of this section will use Apache2 for the web server.

4. configure apache2.conf

apache2.conf configuration by typing :

gedit /etc/apache2/apache2.conf
 

and create a new alias and directing it to /usr/share/ use the following code :

Alias /phpmyadmin/ "/usr/share/phpmyadmin/"
<Directory "/usr/share/phpmyadmin">
Options Indexes Multiviews
AllowOverride None
Order allow,deny
Allow from all
LanguagePriority en cs de es fr it nl sv pt-br ro
</Directory>

 finally try to type in the browser localhost/phpmyadmin/index.php

good luck