Installation MySQL DB test issue

After getting past my initial problems with the database install screen I got a new error:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

I search the osCommerce forum and the MySql forum. Some of the posts in the osCommerce forum suggested downgrading MySql from 4.1 to 4.0. I did find a post that pointed to a discussion in the MySql forum that had a suggestion which I tried and was able to get past this issue.

Open a MySql Command Line and enter:
use mysql;

UPDATE user SET password = old_password('yourpassword') WHERE user = 'theuser';

('theuser' is the user you're using to connect to the database with your application.)

FLUSH PRIVILEGES;

PHP Version

First I needed to install PHP on my windows xp professional pc running Apache 2. So I went to php.net to download the latest version (5.0.4).

I followed the instructions to install in on apache2 and verified my installation.

First thing I ran into was needing to turn resolve_globals on in my php.ini. osCommerce complained about it right away. So I did that and restarted Apache.

Next I created my database and user then ran the osCommerce install. It failed after entering the Database inforamtion. No error message just the resulting page did not complete loading (I just got the top of the screen). After trying various things and reviewing the installation forum on oscommerce I found a post saying to downgrade PHP from 5 to 4.

So I downloaded PHP 4.3.1 and installed it into Apache 2 in place of the PHP 5. Then restarted and tried the installation again. I now get past my previous problem.

In short, to run osCommerce you need to have PHP 4.3.1.

Introduction

I am beginning to use osCommerce and PHP and have decided to post my lessons learned on this blog.

As I am installing and learning osCommerce/PHP on my local machine I will be posting what I learn.