mysql_connect not supported by client?

[Toboe]

i ahvent gotten any answers from my other posts i hope this one gets some.

i keep geting

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\test2\connect.php on line 6
1

now im looking thru the file and it looks right. im using the current veron of mysql 4.1 any ideas?

heres the connect.php

<?
$dbname="";
$dbhost=""; 
$dbuser=""; 
$dbpass="";
mysql_connect($dbhost,$dbuser,$dbpass) OR DIE("1"); 
mysql_select_db($dbname) OR DIE("1");
?>

ive even tried changing the file to this

<?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Not connected : ' . mysql_error());
}

// make foo the current db
$db_selected = mysql_select_db('foo', $link);
if (!$db_selected) {
   die ('Can\'t use foo : ' . mysql_error());
}
?>

from that i get

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\test2\connect.php on line 3
Not connected : Client does not support authentication protocol requested by server; consider upgrading MySQL client

it looks as though mysql_connect is no longer supported with 4.1 so now the question is.. what is supported to connect to mysql?

[devinemke]

the mySQL client library that's bundled with PHP (libmysql.dll) uses 16char hashes for passwords. starting with mySQL 4.1 they now use 41char hashes. if you try to connect using the old client lib then you will see that error "Client does not support authentication protocol requested by server". you basically have 2 choices. if you want to continue using the regular mySQL functions you need to run a query like this:

UPDATE mysql.user SET Password = OLD_PASSWORD('xxx') WHERE Host = 'xxx' AND User = 'xxx';

substitute x's as necessary. the other alternative is to use the new mySQLi functions (in PHP 5.x), which use the newer cleint library (libmysqli.dll).

[Toboe]

ok i do that through the console right?

but will that set my current password backl to the original one (no password) or can i put my current password there? i really sdont want to have a blank password.

will php even release new files for th enew mysql?

i also tried that and it said i had an error in my syntax

near WHERE Host = 'localhost' AND User = 'root'

[devinemke]

Originally posted by Toboe
ok i do that through the console right?

execute the query by whatever means you want: command line, php script, etc...

Originally posted by Toboe
but will that set my current password back to the original one (no password) or can i put my current password there? i really dont want to have a blank password.?

the default install of mySQL sets up a user record with user = "root" and password = ""(blank). this is typically refered to as "root access". you can connect via root access and update/change any user records you wish.

Originally posted by Toboe
will php ever release new files for the new mysql?

they have, like i said, PHP 5.x now has the new mySQLi extension specifically designed for mySQL 4.1.x

Originally posted by Toboe
i also tried that and it said i had an error in my syntax
near WHERE Host = 'localhost' AND User = 'root'

what is the exact query you are running?

[Toboe]

UPDATE mysql.user SET Password = OLD_PASSWORD('oldpassword') WHERE Host = 'localhost' AND User = 'root';

thats what im using.

i downloaded php5.0.2 seemed like less work.. only issue is that IIS 5.1 doesnt seem to wanna work with it (course it doesnt wanna work with 4.3.0 thru 4.3.9 either)

stupi d400 bad request errors

rofl even with the php that has th eclient that upports mysql i get that error

Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\test2\connect.php on line 6

no ideas?