problem with MySQL-PHP conncetion

[emil_baste]

This code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '101347';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
print "Successfully connected.\n";
mysql_close($link);
?>
is usually getting this response:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\webroot\connect.php on line 7
Error connecting to mysql.

HELP!!

[cornercuttinjoe]

I dunno, here is my logon script, you can try it this way.

<?php
define ('DB_USER', 'myUserName');
define ('DB_PASSWORD', 'myPass');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'my_db');

$dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) 
OR die ('error connecting');

@mysql_connect_db (DB_NAME) OR 
die ('connect error' . mysql_error());
?>

i would also look at your mysql_close($link) command. you are closing your link to mysql there, but dont you want to pass your $conn to that? what is $link?

also, why are you closing the connection to mysql right after you connect? arent you going to want to put some queries in there before you close the connection?

[emil_baste]

k. I'll try your logon version. I'm just actually using a script downloaded from a tutorial. I'll let you know if this works out. Thanks.

[emil_baste]

'joe,
i tried your longon script. it gets this response:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\webroot\connect.php on line 9
error connecting

Could it be that my version of mysql is not compatible with my php?

[fyo]

According to numerous posts around, that is indeed the case. You need to use PHP5, if I understand correctly. Try searchign for the error message using your favorite search engine. That should return plenty of specific answers.

[ayed]

emil baste wrote:

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

Run this command in mysql database as you see here:

c:\mysql\bin\mysql -uroot -p101347 mysql
mysql> SET Password for 'root'@'localhost' = OLD_PASSWORD('101347');
exit

That's all 🙂

[bradgrafelman]

Yes, PHP4 does not support the new MySQL 4.1 authentication method. It's entirely different.

You'll need to login to MySQL via a client that does support this new method (the bundled client works fabulous, as ayed pointed out) and use the OLD_PASSWORD() function to reset any MySQL account that you plan on using in a PHP script. Any new user you create will need to have their password set in this manner, too. Adding the 'OLD_PASSWORDS' flag to the MySQL .ini/.conf file will save you from resetting newly created user accounts in the future, but you'll still have to reset old user accounts' passwords that are already using the new algorithm.

Alternative, as has been mentioned, you'll need to upgrade to PHP5 and use the [man]mysqli[/man] library, short for MySQL Improved.

[Ravenous]

May God bless PHPBuilder. This site has saved me so much hassle over the past few years. The latest being the error message in question here. Thanks much!