Trouble configuring home PC to run MySQL with PHP

[brownrv]

Hi,

I've recently setup a test server (on my new home pc) using
PHP 4.4.4
MySql 4.0.21
Apache 2.2.3

where I have copied my working production zencart instance. I downloaded a database backup and a copy of my zencart files and put them on the test server.

The following tools functions are working as expected on my test server:
PHPMyAdmin
MySQL Administrator
http:/localhost/phpinfo.php

I've updated the configure.php files for both zencart and zencart/admin for file paths between my production site and my test server, but both give errors about connecting to the database. I must have missed something someplace.

And while I have made sure to install the lastest MySQL apis, PHP is still not showing them (php 4.4.4 has a default of 3.23.49 client api) even though I have installed the 4.0.21 mysql and mysqli client libraries as extensions.

Any suggestions on what I missed?

Thanks,
Bob

[brownrv]

Hi,

Okay, I've found the problem. Due to the older mysql client, I had to enable the older password hash algorithm.

Here's what I did:
1) updated the accounts to use the older password hash in mysql client cli (with root access)

set password for 'account'@'localhost' = old_password('password');

note: substitute your account, server, and password for your setup.
Addendum: This would be the account that zencart is using to log into the database for your store.

2) Changed MySQL to use old algorithm

I used MySQL Administrator to toggle the old passwords on in the security tab (just a check box)

3) restart MySQL

I used the MySQL tray monitor to do this (toggled it off and then back on).

Actually, I would have prefered to update the client api so this didn't have to happen, but I've not found any help online regarding installation and configuration of a new client for MySQL and PHP that actually has worked for my setup.

Bob