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:[email protected]]
> Sent: Thursday, June 22, 2006 1:38 PM
> To: [email protected]
> 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/[email protected]