Posted by Ehsan on 10/02/89 11:45

Exactly what sort of error do you get? Any error message? Try copying
the DLL to system32 directory instead.

There are some known issues with mysql 4 installation. When trying to
connect to
mysql 4 from php one common error is that it asks to upgrade client or
something like that, cannot remember exactly. To get over that problem
you must be using OLD_PASSWORD() to mysql table for privilege that you
set for different users using the database.

> mysql -u root -pYourPass
> use mysql
> update user set Password = OLD_PASSWORD('YourPass') where User = 'root';
> flush privileges;

Do this for all the users. When you use Grant all .... and setup a
privilege for user, follow the above instruction to instruct mysql to
use OLD_PASSWORD ().

This can also be done using "SET PASSWORD FOR 'root'@'localhost' =
OLD_PASSWORD('YourPass');" command.

Hope this helps somehow.

Thanks and God Bless!!

Ehsan
http://ehsan.bdwebwork.com

[Back to original message]