Need help, struggling installing mysql in Perl v5.10.0

Hi, struggling=20

I have written a script to connect the mysql db

#!/usr/bin/perl -w

use DBI;
#definition of variables
$db=3D"MYTEST";
$host=3D"localhost";
$user=3D"root";
$password=3D"rootpass";

#connect to MySQL database
my $dbh =3D DBI->connect ("DBI:mysql:database=3D$db:host=3D$host:3366",$u=
ser,$password)
or die "Can't connect to database: $DBI::errstr\n=
";

as specified mysql port is 3366 not 3306

but this returns with error,

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC conta=
ins: C:/Perl/site/lib C:/Perl/lib .
) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQ=
Lite, Sponge.
at sample.pl line 11

But I already installed DBD::mysql

C:\Documents and Settings\Administrator>ppm install DBD::mysql
Downloading ActiveState Package Repository packlist...not modified
No missing packages to install

C:\Documents and Settings\Administrator>ppm verify DBD::mysql
ppm verify failed: Package 'DBD::mysql' is not installed

C:\Documents and Settings\Administrator>

I'm using perl version, 5.10.0 built for MSWin32-x86-multi-thread

Any help will be appreciated, Thanks in advanced for all your help=20

regards,
thalapathi b =0A Unlimited freedom, unlimited storage. Get it now=
, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Need help, struggling installing mysql in Perl v5.10.0

------=_Part_141030_22579634.1222252749488
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

The error shows that DBD:mysql has not been installed correctly. Remove and
install again.

On Tue, Sep 23, 2008 at 9:05 PM, thalapathy wrote:

> Hi, struggling
>
> I have written a script to connect the mysql db
>
> #!/usr/bin/perl -w
>
> use DBI;
> #definition of variables
> $db="MYTEST";
> $host="localhost";
> $user="root";
> $password="rootpass";
>
> #connect to MySQL database
> my $dbh = DBI->connect
> ("DBI:mysql:database=$db:host=$host:3366",$user,$password)
> or die "Can't connect to database:
> $DBI::errstr\n";
>
> as specified mysql port is 3366 not 3306
>
> but this returns with error,
>
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
> contains: C:/Perl/site/lib C:/Perl/lib .
> ) at (eval 4) line 3.
> Perhaps the DBD::mysql perl module hasn't been fully installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy,
> SQLite, Sponge.
> at sample.pl line 11
>
> But I already installed DBD::mysql
>
> C:\Documents and Settings\Administrator>ppm install DBD::mysql
> Downloading ActiveState Package Repository packlist...not modified
> No missing packages to install
>
> C:\Documents and Settings\Administrator>ppm verify DBD::mysql
> ppm verify failed: Package 'DBD::mysql' is not installed
>
> C:\Documents and Settings\Administrator>
>
> I'm using perl version, 5.10.0 built for MSWin32-x86-multi-thread
>
> Any help will be appreciated, Thanks in advanced for all your help
>
> regards,
> thalapathi b
>
>
> Unlimited freedom, unlimited storage. Get it now, on
> http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=prajapatikc@gmail.com
>
>


--
Krishna Chandra Prajapati

------=_Part_141030_22579634.1222252749488--

Re: Need help, struggling installing mysql in Perl v5.10.0

------=_Part_118472_882290.1222254874108
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

Where did the mysql.pm library get installed? Can you find it on your
system; and if so, is that location in your path? I suspect not... but
let's find out first.

--
Kenny


On Tue, Sep 23, 2008 at 4:35 PM, thalapathy wrote:

> Hi, struggling
>
> I have written a script to connect the mysql db
>
> #!/usr/bin/perl -w
>
> use DBI;
> #definition of variables
> $db="MYTEST";
> $host="localhost";
> $user="root";
> $password="rootpass";
>
> #connect to MySQL database
> my $dbh = DBI->connect
> ("DBI:mysql:database=$db:host=$host:3366",$user,$password)
> or die "Can't connect to database:
> $DBI::errstr\n";
>
> as specified mysql port is 3366 not 3306
>
> but this returns with error,
>
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
> contains: C:/Perl/site/lib C:/Perl/lib .
> ) at (eval 4) line 3.
> Perhaps the DBD::mysql perl module hasn't been fully installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy,
> SQLite, Sponge.
> at sample.pl line 11
>
> But I already installed DBD::mysql
>
> C:\Documents and Settings\Administrator>ppm install DBD::mysql
> Downloading ActiveState Package Repository packlist...not modified
> No missing packages to install
>
> C:\Documents and Settings\Administrator>ppm verify DBD::mysql
> ppm verify failed: Package 'DBD::mysql' is not installed
>
> C:\Documents and Settings\Administrator>
>
> I'm using perl version, 5.10.0 built for MSWin32-x86-multi-thread
>
> Any help will be appreciated, Thanks in advanced for all your help
>
> regards,
> thalapathi b
>
>
> Unlimited freedom, unlimited storage. Get it now, on
> http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
> http://lists.mysql.com/perl?unsub=kenny@kennyscott.co.uk
>
>

------=_Part_118472_882290.1222254874108--

RE: Need help, struggling installing mysql in Perl v5.10.0

Try here http://cpan.uwinnipeg.ca/PPMPackages/10xx/package.xml, which I
believe contains the DBI package.

Regards

Mark

-----Original Message-----
From: mknscott@googlemail.com [mailto:mknscott@googlemail.com] On Behalf
Of Kenny Scott
Sent: 24 September 2008 12:15
To: bthalapathi@yahoo.co.in
Cc: perl@lists.mysql.com; patg@mysql.com
Subject: Re: Need help, struggling installing mysql in Perl v5.10.0

Hi,

Where did the mysql.pm library get installed? Can you find it on your
system; and if so, is that location in your path? I suspect not... but
let's find out first.

--=20
Kenny


On Tue, Sep 23, 2008 at 4:35 PM, thalapathy
wrote:

> Hi, struggling
>
> I have written a script to connect the mysql db
>
> #!/usr/bin/perl -w
>
> use DBI;
> #definition of variables
> $db=3D"MYTEST";
> $host=3D"localhost";
> $user=3D"root";
> $password=3D"rootpass";
>
> #connect to MySQL database
> my $dbh =3D DBI->connect
> ("DBI:mysql:database=3D$db:host=3D$host:3366",$user,$passwor d)
> or die "Can't connect to database:
> $DBI::errstr\n";
>
> as specified mysql port is 3366 not 3306
>
> but this returns with error,
>
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
> contains: C:/Perl/site/lib C:/Perl/lib .
> ) at (eval 4) line 3.
> Perhaps the DBD::mysql perl module hasn't been fully installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle,
Proxy,
> SQLite, Sponge.
> at sample.pl line 11
>
> But I already installed DBD::mysql
>
> C:\Documents and Settings\Administrator>ppm install DBD::mysql
> Downloading ActiveState Package Repository packlist...not modified
> No missing packages to install
>
> C:\Documents and Settings\Administrator>ppm verify DBD::mysql
> ppm verify failed: Package 'DBD::mysql' is not installed
>
> C:\Documents and Settings\Administrator>
>
> I'm using perl version, 5.10.0 built for MSWin32-x86-multi-thread
>
> Any help will be appreciated, Thanks in advanced for all your help
>
> regards,
> thalapathi b
>
>
> Unlimited freedom, unlimited storage. Get it now, on
> http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
> http://lists.mysql.com/perl?unsub=3Dkenny@kennyscott.co.uk
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org