Download & Unpack MySQL v4.1

Install MySQL v4.1

• Typical Setup
• Skip Sign-Up
• make sure "Configure the MySQL Server now" is checked
• "Detailed Configuration"
• "Developer Machine"
• "Multifunctional Database"
• "InnoDB Tablespace Settings" - leave everything default
• "Decision Support (DSS)/OLAP"
• make sure "Enable TCP/IP Networking" is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
• "Standard Character Set"
• check "Install As Windows Service"
• I recommend leaving "Include Bin Directory in Windows PATH" checked
• enter your root password and I would recommend checking "Root may only connect from localhost"
• then hit "execute" and it'll install and set it up.

Getting PHP5 to work with MySQL

Testing MySQL

<?php
// hostname or ip of server (for local testing, localhost should work)
$dbServer='localhost';

// username and password to log onto db server (what you entered in Step 4)
$dbUser='root';
$dbPass='';

// name of database (what you created in step 4)
$dbName='test';

    $link = mysql_connect("$dbServer", "$dbUser", "$dbPass") or die("Could not connect");
    print "Connected successfully<br>";
    mysql_select_db("$dbName") or die("Could not select database");
    print "Database selected successfully<br>";

// close connection
mysql_close($link);
?>

#!/usr/bin/perl

print "Content-type: text/html\n\n";

# DBI is perl module used to connect to the database
use DBI;								 

# hostname or ip of server (for local testing, localhost should work)
$config{'dbServer'} = "localhost";

# username and password to log onto db server (what you entered in Step 4)
$config{'dbUser'} = "root";		
$config{'dbPass'} = "";			

# name of database (what you created in step 4)
$config{'dbName'} = "test";			

# MySQL driver (shouldn't need to change)
$config{'dataSource'} = "DBI:mysql:$config{'dbName'}:$config{'dbServer'}";	

my $dbh = DBI->connect($config{'dataSource'},$config{'dbUser'},$config{'dbPass'}) or 
die "Can't connect to $config{'dataSource'}<br>$DBI::errstr";
    print "Connected successfully<br>";
$dbh->disconnect();