Authentication Issue

------=_NextPart_000_0027_01C4FE23.E301C130
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

This is my first list communication so I hope I'm sending it to the correct
place.

I'm a newbie running the following set up on an XP Machine

MySQLServ: MySQL 4.1.7-nt via TCP
MySQLClient: MySQL Client 5.0.0
Apache: Apache 2.0.52
PHP: PHP Version 4.3.10

When I try to confirm that the installation of PHP can access MySQL using a
specific user name with a password, I receive the following:

Client does not support authentication protocol

The MySQL manual describes situations where this may occur but the versions
of my software seem to be pretty current.

When I use another test script I consistently get a connection as long as
the user name is not associated with a password. If it has a password, I
get a consistent connection failed message.

Any thoughts?

Thanks, Peter


Peter Crosby CIH, CSP, CHMM
Exposure Assessment Strategies, Inc.
www.eastrat.com
973-655-0145

"Protecting Your Most Important Assets..."



------=_NextPart_000_0027_01C4FE23.E301C130--

Re: Re : Authentication Issue

PHP uses the server client libraries, try upgrading the libmysql and
the other .dll files at the server, and make sure your HTTP Server is
using the latest libraries to access MySQL.

Best regards,

On Wed, 19 Jan 2005 20:27:17 +0200, Greg Quinn wrote:
> Hi Peter,
>
> This will solve your problem...
>
> http://dev.mysql.com/doc/mysql/en/Old_client.html
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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 : Authentication Issue

------=_NextPart_000_0003_01C4FE65.451C6FA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Peter,

This will solve your problem...

http://dev.mysql.com/doc/mysql/en/Old_client.html
------=_NextPart_000_0003_01C4FE65.451C6FA0--

Re: Authentication Issue

As Greg and Daniel stated, make sure your libraries are up to date (php4
requires newer ones to connect to mysql 4.1.x versus mysql 4.0.x).

However, what may be happening here is when you are trying to connect
using no password (I'm assuming you're using the 'root' username) it
works because your mysql installation by default has a blank password
for the root user therefore it just lets you in. Interesting too, I will
have to check into that. Any ways, you will need to update the root user
password so that it is not blank or else your server is wide open to
anyone who can connect to the port the service runs on (3306). Cheers.

Armando

Peter Crosby wrote:
> This is my first list communication so I hope I'm sending it to the correct
> place.
>
> I'm a newbie running the following set up on an XP Machine
>
> MySQLServ: MySQL 4.1.7-nt via TCP
> MySQLClient: MySQL Client 5.0.0
> Apache: Apache 2.0.52
> PHP: PHP Version 4.3.10
>
> When I try to confirm that the installation of PHP can access MySQL using a
> specific user name with a password, I receive the following:
>
> Client does not support authentication protocol
>
> The MySQL manual describes situations where this may occur but the versions
> of my software seem to be pretty current.
>
> When I use another test script I consistently get a connection as long as
> the user name is not associated with a password. If it has a password, I
> get a consistent connection failed message.
>
> Any thoughts?
>
> Thanks, Peter
>
>
> Peter Crosby CIH, CSP, CHMM
> Exposure Assessment Strategies, Inc.
> www.eastrat.com
> 973-655-0145
>
> "Protecting Your Most Important Assets..."
>
>
>

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