OT: MySQL fails to connect

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I'm using Mysql and DBI with Perl to connect to databases.

When I upgraded MySQL server, my perl scripts are not working properly. It gives me this error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

When I tried researching about this topic, I only found that you have to update the client so it supports the new authentication mysql versions 4.1 and up uses.

So what does this mean for me?

Do I need to upgrade the DBI module? Or the MySQL driver? I haven't tried yet, but scared to try because i'm not sure if it will affect my application.

Thank you, Henry

Comment on OT: MySQL fails to connect

Replies are listed 'Best First'.
Re: OT: MySQL fails to connect by rnahi (Curate) on Aug 05, 2005 at 08:32 UTC
See this manual page. It should give you all the information you need. Basically, either you change your password as described in the manual (temporary solution), or you upgrade your DBD::mysql driver.	[reply]
Re: OT: MySQL fails to connect by gellyfish (Monsignor) on Aug 05, 2005 at 08:35 UTC
Yes you should ideally upgrade the MySQL client driver libraries and then recompile the DBD::mysql - however you can work round this (not so ideal) by following the second approach outlined at http://dev.mysql.com/doc/mysql/en/old-client.html /J\	[reply]
Re: OT: MySQL fails to connect by marto (Cardinal) on Aug 05, 2005 at 08:32 UTC
Your right, this is off topic :) Read the documentation here by the software vendor. Before asking a database related question ... may also be worth a read if you have not done so already. Hope this helps. Martin	[reply]