
bthalapathi
New User
Sep 23, 2008, 6:05 AM
Post #1 of 2
(6748 views)
|
Need help, installing mysql in Perl v5.10.0
|
Can't Post
|
|
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
|