PHP does not support MySQL?

ccgorman

I just installed

1) Apache 2.0.52
2) PHP 4.3.10
3) MySQL Server 4.1

On my Windows XP Professional.

Apache and PHP are running fine, and MySQL runs fine on the command line, but when I run a bit of code:

$link = mysql_connect('localhost', 'root', 'password');

I get the error message:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in...

Any ideas how to get PHP and Apache linked up to MySQL, did I miss a step?

Thanks,
Chris

tomhath

Try replacing c:\php\libmySQL.dll with the one from
C:\mysql\bin\libmySQL.dll.

(Your install paths might be different, mysql might be in Program Files)

ccgorman

Hello,

Thanks for your help, I tried to add:

extension=C:\Program Files\MySQL\MySQL Server 4.1\bin\libmySQL.dll

to php.ini, but now I get the error:

Unknown(): Invalid library (maybe not be PHP library)

Any further ideas?

tomhath

Is a dll by that name alalready in your php\dll directory? Try renaming the one there and copying the one from mysql. I don't think you need the line in php.ini.

ccgorman

Start up MySQL in a command line and type

mysql> use mysql;

mysql> UPDATE user set password=old_password('your user password') WHERE user='your user';

Hope this helps future people with the same problem.