Hello, here's the same topic AGAIN.

I'm having problems connecting to a new MySQL database I've created on a seperate server.

I've read the following topics:
need-help-connecting-to-mysql-t2378.html
(and replaced the libmysql.dll successfully used by the MySQL Admin tools into the phped directory)
+
libmysql-dll-upgrade-t3094.html
+
the old passwords directive in the my.ini
(and added this directive in the both of my.ini files)

Plus I've installed both mySQL server 5.0 and 4.1 just to see if reverting to an older DB server helped. (I think this new password authentication was introduced in 4.1 so it does not surprise that reverting to 4.1 does not work. I think I would have to go back to 4.0...)

The behaviour I have is the following:
if I use the helpful DB Client tab in PHPEd, I can connect to either one of the DB servers
if I use MySQL Query Browser, I can connect to either one of the DB servers

But I cannot connect to the database if I try to run and/or debug my PHP script, getting the following error:
: Error mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

I understand this should be fixed by upgrading libmySQL.dll in the <installation directory>/phped but unfortunately it is not.

Any help would be GREATLY appreciated.

Slawek

Slawek, in this situation You must use "OLD_PASSWORD" encryption for user's password.

Ok, do you mean in my.ini on the server? I already added

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

to the end of both (one for each server instance) my.ini

But this did not do anything...

No, No Slawek. Its not a reason from my.ini, not libmysql.dll. The reason is mysql's client (here is mysql extension, right?) which cannot loggin with new encryption of passwords - You must use OLD_PASSWORD for user's account.

Look at it Slawek (are You come from Poland?):

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

OK, that did the trick!! Excellent, thank you very much! I updated the passwords manually from the mysql command line and saw that the password for my user was changed then I could log in.

Dzieki, intro!

---

Tak jestem z Polski ale mieszkam w Kanadzie. Dziekuje z pomoc. Czolem!

Nice I could help.

---
A ja wciaz w Legnicy wegetuje (jeszcze magisterke musze skonczyc, a potem sie zobaczy) - no nie ma za co dziekowac, Pozdrawiam!