error connecting to mysql

I have installed mysql 5.0.0.-alpha-nt version with php version 5 and apache
version 2.0.49. When i try to connect to mysql using php script i get an
error message like this

"Warning: mysql_connect() [function.mysql-connect]: Client does not support
authentication protocol requested by server; consider upgrading MySQL client
in F:\Apache2\htdocs\1.php on line 10"

I cant understand what the problem is.Please suggest me what should i do to
solve thisd problem.Please reply back as soon as possible


thank you.

____________________________________________________________ _____
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01 /


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: error connecting to mysql

The way MySQL authenticates logons has changed for newer versions, the
way the password is encrypted for instance. It seems your PHP code has
been written for an older version of MySQL and may not be suitable for
V5. The PHP documentation may tell you what you want.

John B.

-----Original Message-----
From: sony nakarmi [mailto:sonynakarmi_80@hotmail.com]=20
Sent: Thursday, 17 March 2005 1:03 PM
To: win32@lists.mysql.com
Subject: error connecting to mysql

I have installed mysql 5.0.0.-alpha-nt version with php version 5 and
apache=20
version 2.0.49. When i try to connect to mysql using php script i get an

error message like this

"Warning: mysql_connect() [function.mysql-connect]: Client does not
support=20
authentication protocol requested by server; consider upgrading MySQL
client=20
in F:\Apache2\htdocs\1.php on line 10"

I cant understand what the problem is.Please suggest me what should i do
to=20
solve thisd problem.Please reply back as soon as possible


thank you.

____________________________________________________________ _____
FREE pop-up blocking with the new MSN Toolbar - get it now!=20
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01 /


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: error connecting to mysql

I had this same issue with MySQL 4.1 with MyODBC 3.51 (and I think PHP 4.3).
I got around it by setting the "old-passwords" option in my.ini (If you use
MySQL Administrator: Startup variables > Security > Use old passwords). I
then had to reset the user password.


-----Original Message-----
From: John Bonnett, R&D Australia [mailto:jbonnett@sola.com.au]
Sent: 18 March 2005 01:04
To: sony nakarmi; win32@lists.mysql.com
Subject: RE: error connecting to mysql


The way MySQL authenticates logons has changed for newer versions, the
way the password is encrypted for instance. It seems your PHP code has
been written for an older version of MySQL and may not be suitable for
V5. The PHP documentation may tell you what you want.

John B.

-----Original Message-----
From: sony nakarmi [mailto:sonynakarmi_80@hotmail.com]
Sent: Thursday, 17 March 2005 1:03 PM
To: win32@lists.mysql.com
Subject: error connecting to mysql

I have installed mysql 5.0.0.-alpha-nt version with php version 5 and
apache
version 2.0.49. When i try to connect to mysql using php script i get an

error message like this

"Warning: mysql_connect() [function.mysql-connect]: Client does not
support
authentication protocol requested by server; consider upgrading MySQL
client
in F:\Apache2\htdocs\1.php on line 10"

I cant understand what the problem is.Please suggest me what should i do
to
solve thisd problem.Please reply back as soon as possible


thank you.

____________________________________________________________ _____
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01 /


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=stephenwillcock@yahoo.co. uk


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org