Operation Systems

Installing Apache, MySQL and phpMyAdmin on Ubuntu Linux

Firstly we will need to open console terminal and write the following

User@TheUbuntuBox ~# sudo apt-get install apache2 autoconf automake1.4 autotools-dev libapache2-mod-php5 php5 php5-common php5-curl php5-dev php5-gd php-pear php5-ldap php5-mhash php5-mysql php5-mysqli php5-snmp php5-sqlite php5-xmlrpc php5-xsl php5-imap php5-mcrypt php5-pspell php5-gd autoconf automake1.4 autotools-dev libapache2-mod-php5 mysql-server

We just installed Apache2, MySQL Server and PHP5.

Now we should install the phpMyAdmin

User@TheUbuntuBox ~# su –
User@TheUbuntuBox ~# cd /var/www
User@TheUbuntuBox /var/www# svn checkout https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/tags/STABLE/phpMyAdmin phpMyAdmin
User@TheUbuntuBox /var/www# cd phpMyAdmin
User@TheUbuntuBox /var/www/phpMyAdmin# mkdir config
User@TheUbuntuBox /var/www/phpMyAdmin# chmod o+rw config
User@TheUbuntuBox /var/www/phpMyAdmin# pico config.sample.inc.php

Now we have to setup the phpMyAdmin.
Using the last command “pico config.sample.inc.php” we have opened the configuration file of phpMyAdmin and we should change the following lines:

$cfg[‘blowfish_secret’] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

should be changed to:

$cfg[‘blowfish_secret’] = ‘cookie’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Now we have to set root user and pass:

// $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
// $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;

pma is the username and pmapass is the password.

You can save the file using CTRL + O and then exit the pico editor using CTRL + X.

Now execute the following command:

User@TheUbuntuBox /var/www/phpMyAdmin# mv config.sample.inc.php config.inc.php

Now you have working web server + phpMyAdmin.

Leave a Reply