Help - Client does not support authentication

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Help - Client does not support authentication

Post 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!
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I'm going to guess you're using PHP 4. You'll need to use MySQLi, from what I remember.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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... :?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

For me the most obvious reason is that there is finally support for parameter binding..
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

multi-query ability is nice too. :)
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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???
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
Post Reply