MySql Instalation Problems

[Colin Spicer]

I have just installed MySql 4.1 and PHP 3.0.

Using the command

$dbcnx = mysql_connect('localhost', 'root', '******');

I get an error

"Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\memreehome2.php on line 9"

What am I doing wrong?

All help gratefully received !!

[Designgraphy]

That causes mySQL latest version problem because of the different password authentications.

use mysql;
set password for user@some_host=old_password('yourpass');
flush privileges;

user is the username
some_host is the host
yourpass is the password

[Designgraphy]

If you're not sure where to start first. You'll need to login your mySQL; below:

mysql -u root -p

[Colin Spicer]

I've given up and uninstalled PHP & MySql. I have now downloaded MySql 4.1.8 and PHP 5.0.3. Having gone through the installation procedures outlined in "BYO Database Driven Website" (3rd ed), when I try to restart the WWW Publishing service I get a message "PHP Startup: Unable to load dynamic library 'c:\php\ext\php_mysql.dll' - The specified module could not be found." The path is correct and the file is in that location.

Where am I going wrong. This is driving me NUTS!

Thanks in anticipation . . . . .

[Colin Spicer]

CRACKED IT!!! Had to change the path variable in Control Panel/System to include the PHP and ext directories!

Now to get some code working!

Thanks for your help. Stay close to your pc!

Colin

[Designgraphy]

Oh okay, your welcome!