Installing Apache Mysql PHP in Ubuntu 11.10

LAMP [Linux,Apache,Mysql,PHP] is the most winning combination in today s growning internet to develop dynamic PHP applications. The linux part is replaced by any linux distro like Ubuntu 11.10, Fedora 15, Opensuse 12.1, Debian etc… Linux is the most fast and safest platform to develop PHP applications for todays web.

How to install an Apache2 webserver on an Ubuntu 11.10 with Mysql and PHP is the most popular question. The answer is very simple. With some command line commands or a search in Latest Ubuntu Software center everyone can install the LAMP stack in ubuntu 11.10.

How To Install LAMP (Linux, Apache, MySQL, PHP) On Ubuntu 11.10

All the commands will be executed in the terminal. You can open a terminal using Ctrl+Alt+T shortcut.

Install Mysql 5 on Ubuntu 11.10

The first step is to install Mysql Server in Ubuntu 11.10. Just paste the command in the terminal and press enter:

sudo apt-get install mysql-server mysql-client

This will install the mysql server and mysql client on your ubuntu 11.10. After that it will as the password for the root user of mysql. You can set a password for that. By using this password you can enter into a mysql command mode.

Install Apache 2 Server on Ubuntu 11.10

The next step is install Apache server in ubuntu 11.10. The apache server is used to execute PHP files in the server. By default the server will run on http://localhost and port 80. You can change the server names and ports in apache configuration file.

sudo apt-get install apache2

After installing the apache server Just open firefox and type http://localhost.

You will get a message.

IT Works! This is the default web page for the server. The web server software is running but no content has been added. yet

This is the default apache welcome page. You can edit this file in /var/www/index.html file.

The configuration file for apache server is at  /etc/apache2/apache2.conf.

Additional configurations are stored in subdirectories of the /etc/apache2 directory such as /etc/apache2/mods-enabled (for Apache modules), /etc/apache2/sites-enabled (for virtual hosts), and /etc/apache2/conf.d.

Install PHP 5 on Ubuntu 11.10

The next step is to install php5 on ubuntu 11.10 and extensions for php5.

We can install PHP5 and the Apache PHP5 module by using the following commands.

sudo apt-get install php5 libapache2-mod-php5

We must restart Apache afterwards:

/etc/init.d/apache2 restart

Get the PHP information in Ubuntu 11.10

Get the detailed information of PHP 5 from apache server.

For that just create a file info.php on /var/www

sudo gedit /var/www/info.php

put the following code

<?php
phpinfo();
?>

 

Just call the file in your web browser using the url : http://localhost/info.php.

You will get the complete information of your current php installation.

Getting MySQL Support In PHP5 on Ubuntu 11.1o

To get MySQL connectivity in PHP, we want to install   the php5-mysql package. For that use the following command:

sudo apt-get install php5-mysql

Install PHP Modules on Ubuntu 11.10

It’s a good idea to install some other PHP5 modules as well as you might need them for your applications.

You can search for available PHP5 modules like this:

sudo apt-cache search php5

Install the PHP modules in ubuntu 11.10 by using the following command:

sudo apt-get install  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

These are the php modules to use gd library, curl, pear modules, image magic, mcrypt extension, memmory cache, tidy, xmlrpc, sqllite database etc

Now restart Apache2 Server

sudo /etc/init.d/apache2 restart

Now refresh http://localhost/info.php in your firefox browser and scroll down to the modules section again.

You should now find lots of new modules there, including the MySQL module:

Install phpMyAdmin in Ubuntu 11.10

phpMyAdmin is a great programme to manage mysql database from your web browser. The latest version includes very nice interface and great utilities like inplace edit etc.. By using phpMyAdmin you can create database, edit tables, insert data, export mysql database etc..

To install PHPMyAdmin use the command:

sudo apt-get install phpmyadmin

You will see the following questions after installation:

Web server to reconfigure automatically: <– apache2

Configure database for phpmyadmin with dbconfig-common? <– No

Afterwards, you can access phpMyAdmin under http://localhost/phpmyadmin/

Chive

Chive is also another great programme to manage mysql database from a web browser. This is project is developed using YII PHP frame work. You can download chive from their website.

To install chive on ubuntu 11.10 just extract the zip file and copy the directory chive to /var/www . and then you can access chive mysql manager from web browser http://localhost/chive

You can also use libreoffice base to access and edit mysql database. There is a mysql query builder and entity relation manger in libreoffice base.

Install PHP IDE Geany in Ubuntu 11.10

For developing PHP application you need a good IDE. Geany is a light weight fast ide developed using GTK library. You can install geany by using the command:

sudo apt-get install geany

There are other IDEs like PHP Eclipse, Komodo Edit, Netbeans, gPhpedit, bluefish etc for editing and developing php applications.

Also there are lot of php frameworks available for developing great applications in php like Codeigniter, Cake PHP, Fuel PHP, Kohana, Yii, Zend Framework, Symphony etc… You can try one.

Leave a Reply