Page 1 of 1
Help - Client does not support authentication
Posted: Fri Feb 24, 2006 10:01 am
by mhouldridge
Hi,
I have installed mysql 4.1 and mysql admin and these are running fine. I have also put phpmyadmin within my web root and have attempted to connect to mysql.
I get the following error;
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Now I am very familiar with this error and I have set mysql to use old passwords within the variables however it is still showing this error.
Please help!
Posted: Fri Feb 24, 2006 11:01 am
by feyd
I'm going to guess you're using PHP 4. You'll need to use MySQLi, from what I remember.
Posted: Fri Feb 24, 2006 2:50 pm
by raghavan20
feyd wrote:I'm going to guess you're using PHP 4. You'll need to use MySQLi, from what I remember.
eventhough, I am using mysqli in my office, I do not really know what are the entire list of advantages that comes wtih mysqli over mysql...there are no good links that I could find...

Posted: Fri Feb 24, 2006 2:57 pm
by timvw
For me the most obvious reason is that there is finally support for parameter binding..
Posted: Fri Feb 24, 2006 3:12 pm
by feyd
multi-query ability is nice too.

Posted: Sat Feb 25, 2006 2:04 am
by raghavan20
timvw wrote:For me the most obvious reason is that there is finally support for parameter binding..
you mean to say prepared statements right but feyd, what do you mean by multi-query,,,is it the ability to pass result of one query into another in where clause (multiple-queries)?
I do not see one reason why they have made the mysqli_affected_rows() to return the number of rows in a select statement in mysqli???
Posted: Sat Feb 25, 2006 9:51 am
by feyd
raghavan20 wrote:feyd, what do you mean by multi-query
mysqli_multi_query()
raghavan20 wrote:I do not see one reason why they have made the mysqli_affected_rows() to return the number of rows in a select statement in mysqli???
As the documentation says, mysqli_affected_rows() will work like mysqli_num_rows() for selects, but also returns how many rows were altered by an INSERT, DELETE, or UPDATE query too.