MySql, Perl on Win32

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

I am running MySql 4.1.9 and Perl 5.8.4 on Win2000. This is the message I get when I try to connect: DBI connect('dna','root',...) failed: Client does not support authentication pro tocol requested by server; consider upgrading MySQL client at C:\xampp\xampp\htd ocs\modperl\dna_tk.pl line 6 PHP gives me no problem connecting to the database. Anyone can help? Thanks p.s. I 've been through a lot of searching on the net. not much help

Comment on MySql, Perl on Win32

Replies are listed 'Best First'.
Re: MySql, Perl on Win32 by jdtoronto (Prior) on Jan 21, 2005 at 15:30 UTC
biochris Did you look on mysql.com? Try this link: Documentation search reuslt which comes straight out of the manual in response to your error message. You may need to install updated client libraries from mysql.com and the re-install DBI. jdtoronto	[reply]
Re^2: MySql, Perl on Win32 by mpeters (Chaplain) on Jan 21, 2005 at 16:01 UTC
In addition to the above, it's probably because your perl libs were compiled against a 4.0.x mysql. They changed the way passwords are hashed, so the old client method doesn't work by default wit the server. If you don't want to recompile your perl libs, then you can change the way your server works by adding a `old_passwords` option to the `[mysqld]` section of your my.cnf, and then restarting mysql.	[reply] [d/l] [select]
Re: MySql, Perl on Win32 by nashr (Novice) on Jan 21, 2005 at 17:09 UTC
Along with DBI, try installing DBD::mysql. From CPAN: DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Hope this helps...	[reply]
Re: MySql, Perl on Win32 by dws (Chancellor) on Jan 23, 2005 at 04:58 UTC
Client does not support authentication pro tocol requested by server; consider upgrading MySQL client I'm led to believe, though I haven't tried it myself, that when you install MySQL on Windows and get into the Configuration Wizard, leaving the "Modify Security Settings" box unchecked will get you the old authentication scheme. It might be worth a try.	[reply]