|
|
|
|
|
|
| Author |
Message |
John Bokma
*nix forums Guru
Joined: 23 Feb 2005
Posts: 1136
|
 Posted: Sun May 28, 2006 12:22 am Post subject:
Re: Error In Using Perl To Connect To MySQL
|
|
|
Sherm Pendley <sherm@dot-app.org> wrote:
| Quote: | Louis <t051315@hotmail.com> writes:
Sherm Pendley wrote:
Louis <t051315@hotmail.com> writes:
OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11
Both Perl and MySQL work on my machine. I wanted to test using Perl
to manipulate MySQL data.
I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:
DBI connect('database=mymusic;host=localhost','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at mydbi.pl line 24
No need to upgrade, just give 'root' an old-style password. Have a
look:
http://dev.mysql.com/doc/refman/5.1/en/old-client.html
sherm--
Hi Sherm,
Thank you for your solution. It works. I am still puzzled by the
explanation though. I have never used MySQL pre 4.1. Whatever works.
Are you using ActiveState Perl? If so, and if you're using DBD::mysql
from a PPM, then that's using whatever MySQL client library version that
ActiveState built it against. That could very well be a pre-4.1 version.
|
Yup, Sherm is right, it has to do with how the library talks with MySQL.
If you are going to use MySQL with other programs, like PHP, you might
bump into this issue more often. I am already considering to downgrade to
the MySQL 4.x branch since there might be other issues as well (for
example the handling of defaults IIRC).
--
John Bokma Freelance software developer
&
Experienced Perl programmer: http://castleamber.com/ |
|
| Back to top |
|
 |
Sherm Pendley
*nix forums Guru
Joined: 03 Mar 2005
Posts: 527
|
| Posted: Sat May 27, 2006 11:57 pm Post subject:
Re: Error In Using Perl To Connect To MySQL
|
|
|
Louis <t051315@hotmail.com> writes:
| Quote: | Sherm Pendley wrote:
Louis <t051315@hotmail.com> writes:
OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11
Both Perl and MySQL work on my machine. I wanted to test using Perl
to manipulate MySQL data.
I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:
DBI connect('database=mymusic;host=localhost','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at mydbi.pl line 24
No need to upgrade, just give 'root' an old-style password. Have a
look:
http://dev.mysql.com/doc/refman/5.1/en/old-client.html
sherm--
Hi Sherm,
Thank you for your solution. It works. I am still puzzled by the
explanation though. I have never used MySQL pre 4.1. Whatever works.
|
Are you using ActiveState Perl? If so, and if you're using DBD::mysql
from a PPM, then that's using whatever MySQL client library version that
ActiveState built it against. That could very well be a pre-4.1 version.
sherm--
--
Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org |
|
| Back to top |
|
|
Louis
*nix forums beginner
Joined: 29 Apr 2005
Posts: 4
|
| Posted: Sat May 27, 2006 11:31 pm Post subject:
Re: Error In Using Perl To Connect To MySQL
|
|
|
Sherm Pendley wrote:
| Quote: | Louis <t051315@hotmail.com> writes:
OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11
Both Perl and MySQL work on my machine. I wanted to test using Perl
to manipulate MySQL data.
I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:
DBI connect('database=mymusic;host=localhost','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at mydbi.pl line 24
No need to upgrade, just give 'root' an old-style password. Have a look:
http://dev.mysql.com/doc/refman/5.1/en/old-client.html
sherm--
Hi Sherm, |
Thank you for your solution. It works. I am still puzzled by the
explanation though. I have never used MySQL pre 4.1. Whatever works.
Thank you very much. |
|
| Back to top |
|
|
Sherm Pendley
*nix forums Guru
Joined: 03 Mar 2005
Posts: 527
|
| Posted: Sat May 27, 2006 8:08 am Post subject:
Re: Error In Using Perl To Connect To MySQL
|
|
|
Louis <t051315@hotmail.com> writes:
| Quote: | OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11
Both Perl and MySQL work on my machine. I wanted to test using Perl
to manipulate MySQL data.
I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:
DBI connect('database=mymusic;host=localhost','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at mydbi.pl line 24
|
No need to upgrade, just give 'root' an old-style password. Have a look:
<http://dev.mysql.com/doc/refman/5.1/en/old-client.html>
sherm--
--
Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org |
|
| Back to top |
|
|
Louis
*nix forums beginner
Joined: 29 Apr 2005
Posts: 4
|
| Posted: Sat May 27, 2006 6:59 am Post subject:
Error In Using Perl To Connect To MySQL
|
|
|
OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11
Both Perl and MySQL work on my machine. I wanted to test using Perl to
manipulate MySQL data.
I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:
DBI connect('database=mymusic;host=localhost','root',...) failed: Client
does not support authentication protocol requested by server; consider
upgrading MySQL client at mydbi.pl line 24
My problems:
1) I installed MySQL. I couldn't find separate server and client
installations. So I am not sure how to "upgrade client".
Appreciate for any help. Thank you. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Jan 09, 2009 6:02 am | All times are GMT
|
|
Mortgage | BabbFest | Personal Finance | Credit Counseling | Adverse Credit Remortgage
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Programming
»
Perl
»
modules
