Ihave been previously been using PHPtriad to create my website for development purposes. We are now at the stage to deploy the site onto a 'real' server. The phptriad used Apache, PHP 4.1 and a version of mysql. As some of you might now, the mySQL service wasnt installed onto the system.
On the new 'real' server. I have setup PHP using the zip package (not the installation package) and have setup IIS to allow PHP, I can run a PHPinfo() script.
I then installed mySQL using the package installation, I have setup the tables that are required to run my site. However i now get this error message:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\Inetpub\wwwroot\partscataloguev3\inc\connect.php.inc on line 8
Can anyone exlpain what it means, what i should do and how i should do it?? also..can anyone show me a repository of how to setup up database users?? the manuals seem to assume that you toally understand everything about MySQL (SQL) to set it up??