WAMP Server

This is a work in progress

For the non compuer vegies amongst us, WAMP that stands for Windows Apache Mysql PHP.

Apache is a web server program.
Mysql is a database program
PHP is a programming language that effectively is the glue between the data in the database (mysql) andweb page that the user sees on their browser served out by the web server program (Apache).

Normally I install each of these separately but on this occasion I have used a prepacaged installer interestingly called WAMP.  There are many such installers and I chose this one for no particular reason.

After it was installed, PHPMYADMIN reported that Mysql was configured with no root password.
Fixed -> See below.
Then I get a error with PDO - as at 18-SEP-2012- NOT fixed

To change this, open a Mysql console.  This can be done via the WAMP icon on the task bar.

At the Mysql> prompt you can type set password
 then type this

set password for 'root'@'localhost' = password('newpasswordgoeshere');
and it shoud respond:
Query OK, 0 rows affected (0.00 sec)

Now we have to tell PHPMyAdmin that Mysql has a password.
Use a text editor to change these lines in the PhpMyAdmin congiguration file:

C:\wamp\apps\phpmyadmin3.5.1\config.inc.php
//$cfg['Servers'][$i]['password'] = '';  //none <- comment out
$cfg['Servers'][$i]['password'] = ''newpasswordgoeshere';  //<-Add

Restart everything and it all worked.
----------------------------
PDO PROBLEM
I get this error when running an example from "agiletoolkit.org" and I get a similar error when trying the ajax database example from HTML5builder

PDO error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

Here is the screen shot 18-SEP-2012

PDO stands for PHP Data Objects.  It is enabled in the WAMP server.
This picture seems to show that PDO is included and checking php.ini seems to confirm that.
I assume that PDO does not know the root password for mysql and I do not know how it finds that out.