Connection not working on server

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

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

Connection not working on server

Post 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
Charles256
DevNet Resident
Posts: 1375
Joined: Fri Sep 16, 2005 9:06 pm

Post 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 :-/
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post 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?
Charles256
DevNet Resident
Posts: 1375
Joined: Fri Sep 16, 2005 9:06 pm

Post by Charles256 »

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

Post 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
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Also updated to version 4.4.1 which from another article should fix this problem.

Argh!!!!
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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');
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post 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?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

mhouldridge wrote:within the mysql interface?
yes
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post 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!!!!
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

I get cant find any matching row in the user table
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

ahhh.... nmight be working now

got wrong user
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Sorted!!!

Its working now!


Thank you Master!
Post Reply