in reply to Unable to connect to database

I removed the modules which i installed manually. Now if i am trying to install using cpan i get the error:

C:\PROGRA~1\MySQL\MYSQLS~1.6\bin\MYSQLA~1.EXE: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' Problem running C:\PROGRA~1\MySQL\MYSQLS~1.6\bin\MYSQLA~1.EXE - aborting ... Warning: No success on commandC:\Perl\bin\perl.exe Makefile.PL INSTALLDIRS=site

and if i install the module from ppm then i get the following error:

Downloading DBD-mysql-4.011...redirect Downloading DBD-mysql-4.011...failed 401 Authorization Required ppm install failed: 401 Authorization Required

Replies are listed 'Best First'.
Re^2: Unable to connect to database
by marto (Cardinal) on Aug 08, 2013 at 09:15 UTC

    5.8.8 is from 2006, consider upgrading. Either read the documentation regarding manual installation or add more PPM repos via PPM::Repositories.

      I just upgraded my perl from 5.8.8 to 5.16.3, and installed the modules without any error, now i am successfully able to run the script. Thanks!!
        plz give me step by step procedure to install DBD-Mysql for 5.16.3
Re^2: Unable to connect to database
by poj (Abbot) on Aug 08, 2013 at 07:22 UTC

      perl -v gives me

      This is perl, v5.8.8 built for MSWin32-x86-multi-thread (with 12 registered patches, see perl -V for more detail) Copyright 1987-2007, Larry Wall Binary build 824 287188 provided by ActiveState http://www.ActiveState.com Built Sep 3 2008 11:14:55 Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page.