Page 1 of 1

authentication protocol error. Please Help!

Posted: Tue Apr 13, 2004 12:29 pm
by yosuke_
Hi!
Im new to MySQL database and PHP, but I have one problem. I created a database, Created new user account for with all privileges. But when I try to connect to database I get this error:
mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
And my code is this:

Code: Select all

<?php
mysql_connect("localhost","yosuke", "password");
mysql_select_db("myData");

$SQL = "SELECT * FROM users";
$Query = mysql_query($SQL);
while ($results = mysql_fetch_array($Query));
echo $results["firstname"];
?>
What is wrong? I have MySQL 5. Please help me. Thank you!

Posted: Tue Apr 13, 2004 12:31 pm
by magicrobotmonkey
You are going to need to look in your PHP.ini file and see what your authentication protocal is

Posted: Tue Apr 13, 2004 3:50 pm
by yosuke_
I searched php.in file for authentication, and this is only thing what I found:

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

any ideas?

Posted: Tue Apr 13, 2004 6:04 pm
by JAM

Posted: Tue Apr 13, 2004 6:17 pm
by markl999
I have MySQL 5
Might want to look at the mysqli functions as they are much more suited to MySQL 4.1.2 or above.