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!