Skip navigation links
2.13.3 Problems Using the Perl DBI/DBD Interface »
Section Navigation      [Toggle]

2.13.2. Installing ActiveState Perl on Windows

On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl:

  1. Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install it.

  2. Open a console window.

  3. If necessary, set the HTTP_proxy variable. For example, you might try a setting like this: 

    C:\> set HTTP_proxy=my.proxy.com:3128

  4. Start the PPM program: 

    C:\> C:\perl\bin\ppm.pl

  5. If you have not previously done so, install DBI: 

    ppm> install DBI

  6. If this succeeds, run the following command: 

    ppm> install DBD-mysql

This procedure should work with ActiveState Perl 5.6 or newer.

If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: 

use DBI;
$dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) ||
  die "Got error $DBI::errstr when connecting to $dsn\n";
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices

User Comments

Posted by [name withheld] on March 18 2006 9:14am[Delete] [Edit]

Using ActivePerl 5.8.4.816 and WinXP.

...\perl\bin\ppm.bat
ppm> install DBI
ppm> install DBD-MySQL

Also worked like a charm.

Posted by Janet Eivers on November 8 2007 1:35am[Delete] [Edit]

Here's my take, hope it's useful to somebody - I'm really new to developing but wanted to try out perl with MySQl. I already had a WAMP package installed so found my way to this page via google (after trying the page that lists DBI and DBD-MySQL, all of which i found really confusing:)
On this page I followed this link http://www.activestate.com/Products/ActivePerl/ and downloaded the free standard version. Needless to say it was a zipped file which i unzipped to a new folder I created on my C: drive.
In that folder was a file called Installer.bat. I double clicked the file and the package installed via the command prompt window (got asked a series of questions:), nevertheless it installed - phew!!
I then followed Nish's instructions to check the version and change directories and execute the command:
c:\perl\bin>ppm
a lovely GUI opened! and I was able to see what packages were installed and what were not. DBI was already installed (no work for me there) DBD-MySQl was not so I simply highlighted the package I wanted to install and the ppm downloaded the file for me. All that was left to do was to use the icon in the ppm (marked 'run') and - hey presto - DBD MySQL was installed for me - genius - :)

Now I can start figuring where is the best place to learn how to write perl code to work with MySQL and trying it out on my machine.
This worked on windows xp with sp2

Posted by Mattias Malmgren on June 18 2008 12:05pm[Delete] [Edit]

For ActivePerl 5.10.0 Build 1002 use:

ppm install http://cpan.uwinnipeg.ca/PPMPackages/10xx/DBD-mysql.ppd

Posted by José Raúl Arana Holguín on December 17 2008 8:19pm[Delete] [Edit]

On PPM GUI over activeperl 5.10 you have to follow this steps to obtain DBD-mysql
1. On the PPM GUI press Ctrl+P
2. There is a tab named suggested, you have to select uwinnipeg and press add and then ok.
3. It will add more packages to your activeperl.
4. Now you can find DBD-mysql on the search bar in the main window of the PPM.

Posted by Chris Calender on October 3 2011 5:02pm[Delete] [Edit]

If the above doesn't work, as did not for me with ActivePerl 5.12.4, then try these 2 commands:

ppm rep add http://theoryx5.uwinnipeg.ca/ppms/
ppm install dbd-mysql

For reference, you can read the full tutorial/walk-through here:

http://www.chriscalender.com/?p=251

Add your own comment.