Page 1 of 1

Connection not working on server

Posted: Wed Nov 23, 2005 4:06 pm
by mhouldridge
Hi,

My php connection string works on every server except our latest one.

It is running mysql 4.1

Here is the error I get on the site;

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in F:\kp\db.php on line 2
Problem connecting


I dont know how to fix this.

Please help

Posted: Wed Nov 23, 2005 4:08 pm
by Charles256
.............................
http://www.google.com/search?hs=4Uh&hl= ... tnG=Search

or you could just google your error message...check out the VERY first LINK.

edit: and this is practically the same problem you posted a few threads back..you change the page name and line number :-/

Posted: Wed Nov 23, 2005 4:16 pm
by mhouldridge
Yep Ive looked at that before, but no good.

I enter the use old passwords within ym php.ini however It doesnt fix it.

Should I consider upgrading php?

Posted: Wed Nov 23, 2005 4:18 pm
by Charles256

Posted: Wed Nov 23, 2005 4:41 pm
by mhouldridge
Yep, tried that one too.

It is kinda the same as the other solution.

I have updated php however the same problem continues.....

Hmm.... I can only think that a permissions issue within IIS is causing a problem...... hmm... dont know though

Posted: Wed Nov 23, 2005 4:49 pm
by mhouldridge
Also updated to version 4.4.1 which from another article should fix this problem.

Argh!!!!

Posted: Wed Nov 23, 2005 4:57 pm
by Burrito
discussed this on several occasions we have...try searching the forums you should:

hint:

Code: Select all

set password for user@host = old_password('password');

Posted: Wed Nov 23, 2005 4:59 pm
by mhouldridge
Ahhh Yoda,

I need your help, I am always greatful for your wise words.

I will give that a go, within the mysql interface?

Posted: Wed Nov 23, 2005 5:01 pm
by Burrito
mhouldridge wrote:within the mysql interface?
yes

Posted: Wed Nov 23, 2005 5:05 pm
by mhouldridge
still not working

I tried the following at the mysql prompt

admin@localhost =PASSWORD_(mypassword)

also tried your suggestion.

REstarting mysql too......


ARGH!!!!

Posted: Wed Nov 23, 2005 5:08 pm
by Burrito
no no no....log into the CLI of mysql then type this you must:

Code: Select all

set password for admin@localhost = old_password('password');
type it exactly (replacing your username and password) you must.

Posted: Wed Nov 23, 2005 5:12 pm
by mhouldridge
I get cant find any matching row in the user table

Posted: Wed Nov 23, 2005 5:13 pm
by mhouldridge
ahhh.... nmight be working now

got wrong user

Posted: Wed Nov 23, 2005 5:14 pm
by Burrito
show me the command you're using you should.

have a username named "admin@localhost" do you?

use the same password you created when you ran the "grant all privileges on...." statement you should.

Posted: Wed Nov 23, 2005 5:15 pm
by mhouldridge
Sorted!!!

Its working now!


Thank you Master!