2 messages in com.mysql.lists.win32Re: Authentication Issue| From | Sent On | Attachments |
|---|---|---|
| Peter Crosby | 19 Jan 2005 09:38 | |
| Armando | 19 Jan 2005 17:34 |
| Subject: | Re: Authentication Issue |
|---|---|
| From: | Armando (diji...@shaw.ca) |
| Date: | 01/19/2005 05:34:40 PM |
| List: | com.mysql.lists.win32 |
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..."