authentication protocol error. Please Help!
Posted: Tue Apr 13, 2004 12:29 pm
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:
What is wrong? I have MySQL 5. Please help me. Thank you!
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"];
?>