php using msql_connect

------_=_NextPart_001_01C69633.56DD4C77
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Does anyone know why when I run a php script to connect to mysql server
I get the error "Client does not support authentication protocol
requested by server; consider upgrading MySQL client " I am using the
latest version of Mysql 5.0, also using the latest version of php 5.0.2.
The php module is being loaded through the http.conf file, I can look at
phpinfo() and see that "dir mod_php" is loaded. I have gone into the
admin program and set the option to allow the usage of Old Passwords in
the security tab. Any ideas?

Thanks

=20

Rick DeRousse

National Hispanic University

=20

=20


------_=_NextPart_001_01C69633.56DD4C77--

RE: php using msql_connect

Greetings Rick,

Typically this is caused by actually using an older client (you may find php
is using an older version) so I would recommend that you are in fact using
the mysql 5.x client. This can be verified via phpinfo() under 'mysql
client'

The other common cause is due to the wrong authentication scheme in place.
Verify you can actually log in with the servers credentials from the client.
If this error persists then you would probably be able to verify what is
causing it from this method.

If you are using Mysqladmin, you will continue to have permission
issues...toss it.

Cheers,


James Friesen.


> -----Original Message-----
> From: Rick De Rousse [mailto:rderousse@nhu.edu]
> Sent: Thursday, June 22, 2006 1:38 PM
> To: win32@lists.mysql.com
> Subject: php using msql_connect
>
> Does anyone know why when I run a php script to connect to
> mysql server I get the error "Client does not support
> authentication protocol requested by server; consider
> upgrading MySQL client " I am using the latest version of
> Mysql 5.0, also using the latest version of php 5.0.2.
> The php module is being loaded through the http.conf file, I
> can look at
> phpinfo() and see that "dir mod_php" is loaded. I have gone
> into the admin program and set the option to allow the usage
> of Old Passwords in the security tab. Any ideas?
>
> Thanks
>
>
>
> Rick DeRousse
>
> National Hispanic University
>
>
>
>
>
>



--
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