Installation Problem [RESOLVED]

[usamaalam]

Hello everybody,

I am not a PHP developer, but need to run a PHP/MySQL application on my system. I installed different versions of PHP and MySQL and trying to run the application, I can access database, run queries etc., I can run PHP pages, but I cannot connect PHP app with MySQL database.

Sometimes, the methods are not recognized by the compiler, sometimes, it says client version is not supported etc.

I just need to know, what version of MySQL (Server and client) to be installed, what version of PHP to be installed, which one to install first, and where to get these things.

I am using Win 2000 Professional.

Thanks.

[john tindell]

What version of PHP and MySQL do you have installed, whats the application your trying to run and what are the exact error messages that are displayed.

[usamaalam]

I installed MySql 4.1.11 (SqlYog client) and PHP 4.2.2. I am getting something client version is not supported, consider upgrading the server etc. I will check the actual message from my office and let you know.

Thanks.

[john tindell]

Im not sure exactly what version of MySQL it was but they changed their authentication method. This means that the older versions of PHP cant connect, try using a newer version of PHP. This should solve your problem if it is a problem with MySQL authentication methods and PHP.

[usamaalam]

Here's the error message I am getting.

Client does not support authentication protocol requested by the server; consider upgrading MySql client.

I tried php 5.x and getting some other error message. I think its MySql (server or client) version problem.

What version of MySql you guys use with PHP 4.2.2 and where can I get it?

Thanks.

[AIS4U]

usamaalam:

I would suggest that you get the latest versions of MySQL and PHP.

Get them here:

http://dev.mysql.com/downloads/

http://www.php.net/downloads.php

I am pretty sure the latest version for each is 5.x

Good Luck

[usamaalam]

I have got MySql 4.0.21 and PHP 4.3.1 and its working now.

Thanks.