Step 1: You start by installing mysql
sudo apt-get install mysql-client mysql-server
Specify new password for the MySQl “root” user when prompted. Repeat it for a second time and you would have MySQL server and client installed.
Step 2: Next, install Apache2:
sudo apt-get install apache2
And you get apache2 installed as well. To double check, point your browser to http://localhost, and you should see the Apache2 placeholder page like this.
Step 3: To install support for PHP, do the usual
sudo apt-get install php5 libapache2-mod-php5
To verify that everything installed correctly and php support is enabled, you need torestart apache by doing this
sudo /etc/init.d/apache2 restart
Create a test php file called info.php, using a text editor of your choice (say gedit)
sudo gedit /var/www/info.php
and paste the following content and save the file
Now open the following page http://localhost/info.php and you should see something like this
Step 4: To make MySQL, php and apache talk among themselves, you would have to install php5-mysql, below I am listing some more useful packages that you might want to install
sudo apt-get install php5-mysql php5-curl php5-gd php5-idn 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-common
Now refresh the info.php page that you have open in your browser and you should be able to see the support for mysql if you search for it by doing Ctrl+f, but before that don’t forget to restart apache again (sudo /etc/init.d/apache2 restart)
Step 5: Finally install phpmyadmin
sudo apt-get install phpmyadmin
It would ask if you want to configure it automatically for apache or lightppd choose apache (by pressing “spacebar” to display a star as shown below and then use tab to navigate to Ok and press enter.
It would be automatically configured, however it would ask if you want a database installed and configured, choose yes and press enter
On the next screen you would be asked to enter the MySQL root password, that you provided in first step
next it would ask you to enter a password to be used by phpmyadmin to register with thedatabase (basically it would create a user called “phpmyadmin” the password is for that, most likely you won’t be needing this password ever. You can even choose to assign a random password for it.
Confirm that password on the next screen. Once you have made your choices the installation would finish and you should be able to access phpmyadmin by pointing your web browser to http://localhost/phpmyadmin/
**You might need to restart apache again, for the above link to start working! (I didn’t have to restart apache, though.)