simple setup of php based web interface to a mysql database

This tutorial uses Ubuntu 7.10 the Gutsy Gibbon, Apache 2.0 , php5 and mysql

The follwoing main phpases are used:



- install Apache

- install mysql

- configure mysql - add users , create databases on mysql

- configure Apache

- install myPhpAdmin

- configure myPhpAdmin



1.Install Apache

#INSTALL APACHE

sudo apt-get install apache2

#Start or stop Apache
sudo /etc/init.d/apache2 stop | start | restart
#if installation of previous packages has failed
dpkg --configure -a

#install PHP mod_php for Apache
sudo apt-get install php5 libapache2-mod-php5

echo '' > /var/www/test.php
open http://localhost/test.php - > you should see Haudi World

2. Install mySQL

#if installation of previous packages has failed

dpkg --configure -a
sudo /etc/init.d/apache2 stop | start | restart

#install mysql server
sudo apt-get install mysql-server
#when prompted type in your password

#if not prompted the command to get to the mysql prompt is :

mysql -uroot -pmysql

#set the password with the following:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('SecretPass');
#run the mysql with:
mysql -uroot -pSecretPass

#view the databases

show databases ;

#create a database with one table

create database testdb ;

use db_test

CREATE TABLE tb_testtable(
column0 INT PRIMARY KEY AUTO_INCREMENT,
column1 VARCHAR(100),
column2 VARCHAR(10) ) TYPE=INNODB;

3. Intall php

#install the php admin
sudo apt-get install libapache2-mod-auth-mysql php5-mysql
#when prompted configure the type of servers

#Other php modules usefull for development
apt-get install php5-gd
apt-get install php5-ldap
apt-get install php5-mysql
apt-get install php5-openssl
apt-get install php5-pear

4. Install phpMyAdmin

Download the latest stable build of phpMyAdmin [[http://surfnet.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.bz2]]

#place the tar under a phpMyAdmin folder (you would have to create it mkdir /var/www/phpMyAdmin ) under your doc root folder

mv /home/user/downloads/phpMyAdmin-2.11.3-all-languages/ /var/www/phpMyAdmin

tar -xvf phpMyAdmin-2.11.3-all-languages.tar.bz2

#configure the most sipliest (not sucure !!!) setup

vim /var/www/phpMyAdmin/config.inc.php

paste the following code in it:

==============================COPY PASTE START


$cfg['blowfish_secret']='shazaam' ; // use here a value of your choice
$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
?>

==============================COPY PASTE END

Go to the login page :

http://localhost/phpMyAdmin/

Login in with the same password you set up during the mysql configuration(here user:root pass:SecretPass)

>