Re: Client authentication error -- suddenly
Dan Bolser <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Sounds like you mysql server verion got upgraded / you are running
different server versions on different ports (and different data
hopefully!).
MySQL server 4+ requires clients of 4+ (as far as I know).
Upgrade your client or downgrade your server.
P.S. After killing a job, 'check table' can be usefull :)
Dan.
On Mon, 8 Nov 2004, Glenn Fleishman wrote:
>Howdy, folks,
>
>I'm running MySQL 4.1.7 on a Red Hat 9 box, and this morning,
>abruptly, I started receiving this error (specifics replaced for
>security purposes):
>
>DBI connect('DATABASE:IP','USER',...) failed: Client does not support
>authentication protocol requested by server; consider upgrading MySQL
>client at [script path]
>
>I had 2.9003 installed and installed 2.9005_3 in case that was the
>problem. I had DBI 1.40 installed and upgraded to 1.45, as well. I
>cannot seem to get this to work.
>
>I checked the MySQL documentation and tried to switch to "old
>passwords" to see if that helped. No luck.
>
>I can't figure out why this suddenly happened at 6 am with me being
>the only person with access to the databases and the Web server, and
>not making any changes.
>
>I had just stopped a large MySQL select operation that had been
>running for 12 hours. But it was running on another instance of MySQL
>-- I have two instances at different ports with different paths
>running.
>
>Any help is very very welcome, as my system is currently down.
>
>
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]