Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Can't locate DBD/mysql.pm in @INC

Hi!

I'm trying to use mySql database whit perl scripts. I wrote the following script:


----------------------------------

#!/usr/bin/perl


use strict;

use DBI;


my $dbh = DBI->connect(

"DBI:mysql:dbname=mydb",

"user12",

"34klq*",

{ RaiseError => 1 },

) or die $DBI::errstr;


my $sth = $dbh->prepare("SELECT VERSION()");

$sth->execute();


my $ver = $sth->fetch();


print @$ver;

print "\n";



$sth->finish();

$dbh->disconnect();

----------------------------------


but in terminal I get:


mbp-di-marco:myperl marcomac$ perl my_script.pl

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/auto/DBD /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/BDB /opt/local/lib/perl5/site_perl/5.12.4/BDB /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/BDB /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level /opt/local/lib/perl5/site_perl/5.12.4 /opt/local/lib/perl5/vendor_perl/5.12.4/darwin-thread-multi-2level /opt/local/lib/perl5/vendor_perl/5.12.4 /opt/local/lib/perl5/5.12.4/darwin-thread-multi-2level /opt/local/lib/perl5/5.12.4 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl .) at (eval 5) line 3.

Perhaps the DBD::mysql perl module hasn't been fully installed,

or perhaps the capitalisation of 'mysql' isn't right.

Available drivers: DBM, ExampleP, File, Gofer, Multiplex, Proxy, Sponge.

at available_drivers.pl line 7.



What can I do to make it work?

Thank you.

MacBook Pro (13-inch Mid 2012), OS X Mavericks (10.9.1)

Posted on Jan 23, 2014 12:06 AM

Reply
3 replies

Can't locate DBD/mysql.pm in @INC

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.