I have successfully gotten PHPED to open my database in the IDE, but when I run my scripts, I am getting the same error, and when I look at phpinfo it tells me I am using 3.23 client. Is there a work around for this, other than installing PHP 5.0?

This problem relates to php itself. Php4 has no extension to work with mysql 4.1. You may want to downgrade to mysql 4.0 or upgrade to php5.

Open a mysql console

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('xxxxxx');

MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients and software.

If you get:

Fatal error: Call to undefined function: mysql_connect()

PHP 5 no longer enables MySQL by default (nor does it bundle the MySQL Client libraries). Instead, you'll need to manually install this extension, just like you do with most every other extension.

Go to your php.ini file (located by default in ...\nusphere\phped\php5) and uncomment de line:

extension=php_mysql.dll

And now it should work fine!

phped build 4048 eval doesn't work with Mysql 4.1.

What is the release that works with mysql 4.1?

I've tried to copy C:\Programmi\MySQL\MySQL Server 4.1\bin\libmySQL.dll on
C:\Programmi\nusphere\phped\php\libmySQL.dll but i've the same error

and what's the error message?

the error is "1251 - client does not support authentication protocal requested by server; consider upgrading mySQL client."

For the moment on my local server I've put "old_passwords" in my.ini, it works, but it's not a solution because I would use the new auth procedure.

it means that you still run old mysql client.
Check if libmysql.dll is really updated and if no older versions are in the directories listed in PATH.