Installing MYSQL

Download and Extract mysql-1.1.22-win32 and run setup
Choose typical install

Choose to skip registration

Choose to configure mysql

Choose standard config

Accept the defaults

Set a password for the root

Finish the install

For php5 copy
C:/php5/libmysql.dll to c:/windows/system32

Configuring the MYSQL
One of the best tools for database manipulation and modification is phpmyadmin.

First configure virtual host database as you configured your site1 etc use directory for both apache configurations ie

C:\program files\apache\apache\database

Download and extract

Phpmyadmin-2.9.1.1-english
to
C:\program files\apache\apache\database

under
C:\Program Files\Apache Group\Apache\database

Copy
config.sample.inc.php
to
config.inc.php

edit config.inc.php in both apache and apachephp5 directories

change youpasssting and yourrootpass to the passwords you set in following
$cfg['blowfish_secret'] = 'youpassstring’

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'yourrootpass';

now

Run a cmd prompt and
Cd c:\program files\mysql\mysql server 4.1\bin

Now to configure the connection from phpmyadmin

Mysql –u root –p
Enter your root password then at mysql prompt

Set password for root@localhost = old_password('yourrootpass');

Where yourrootpass is your root password for mysql
Quit your command prompt By typing
quit
In your browser access http://database/index.php

and login as root with your password also try

http://database:8080/index.php for php5


In phpMyAdmin find one of the two files in the scripts folder:
If you are using a mySQL version lower than MySQL 4.1.2, then find and run create_tables.sql

If you are using a mySQL version higher than MySQL 4.1.2, then find and runcreate_tables_mysql_4-1-2+.sql

Scripts are in myphpadmin directory under scripts