If upgrading is not an option for whatever reason, add the following to the [mysqld] section of my.cnf and then restart mysql:<br><br>old_passwords=1<br><br>Then, for the Mysql user you are connecting with, change the password to use the old encryption scheme:
<br><pre class="programlisting">SET PASSWORD FOR '<em class="replaceable"><code>some_user</code></em>'@'<em class="replaceable"><code>some_host</code></em>' = OLD_PASSWORD('mypass');<span style="font-family: arial,sans-serif;">
<br><br>erik<br></span></pre><br><div><span class="gmail_quote">On 8/19/07, <b class="gmail_sendername">Wayne Walker</b> <<a href="mailto:wwalker@bybent.com">wwalker@bybent.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Sun, Aug 19, 2007 at 06:37:23PM -0700, the New me wrote:<br>> Hi:<br>><br>> I've been trying to install perl and link to Mysql<br>> server,<br>><br>> downloaded indigoperl and installed it,<br>> this went fine,
<br>><br>> tried to run and test<br>><br>> mysqlsamp.pl<br>><br>> but it gave these messages:<br>><br>> C> MySQL Sample Test Script V1.0 on Sun Aug 19<br>> 21:23:30 2007<br><hr><br>
> Can't connect to the mysql server.<br>> <br>Client does not support authentication protocol<br>> requested by server; conside<br>> r upgrading MySQL client at<br>> c:/DevSoftware/perl/site/lib/DBD/mysqlPP.pm line 109
<br><br>The problem is that the mysql client software on your machine. If you<br>installed it separate from IndigoPerl then upgrade MySQL. If it was<br>part of IndigoPerl, you are at the mercy of Indigo.<br><br>--<br><br>
Wayne Walker<br><br><a href="mailto:wwalker@bybent.com">wwalker@bybent.com</a> Do you use Linux?!<br><a href="http://www.bybent.com">http://www.bybent.com</a> Get Counted! <a href="http://counter.li.org/">
http://counter.li.org/</a><br>Perl - <a href="http://www.perl.org/">http://www.perl.org/</a> Perl User Groups - <a href="http://www.pm.org/">http://www.pm.org/</a><br>Jabber: <a href="mailto:wwalker@jabber.gnumber.com">
wwalker@jabber.gnumber.com</a> AIM: lwwalkerbybent<br>IRC: wwalker on <a href="http://freenode.net">freenode.net</a><br>_______________________________________________<br>Austin mailing list<br><a href="mailto:Austin@pm.org">
Austin@pm.org</a><br><a href="http://mail.pm.org/mailman/listinfo/austin">http://mail.pm.org/mailman/listinfo/austin</a><br></blockquote></div><br>