Hi,
I am trying to connect to MYSQL through my perl script.I am using windows 2000 and
activeperl.
I am using Net::MySQL to connect with database.But it is giving error :
Couldn't connect to /tmp/mysql.sock: at E:\PERLTR~1\perl\VALIDA~1.PL line 12
My script is as follows:
#!/usr/local/bin/perl
print "Content-type:text/html\n\n";
use Net::MySQL;
$DBHOST = "localhost";
$DBNAME = "sitebuilder";
$DBUSER = "sa";
$DBPASS = "";
my $mysql= Net::MySQL->new($DBHOST, $DBNAME , $DBUSER, $DBPASS);
$mysql->query(q{SELECT sLoginId,sFirstName,sLastName FROM userdetail});
my $record_set = $mysql->create_record_iterator;
while (my $record = $record_set->each) {
printf "First column: %s Next column: %s\n",
$record->[0], $record->[1],$record->[2];
}
Please Can u help me?
Thanks in advance!
Pankaj