You'll need DBI and DBD::mysql in order to use Class::DBI::mysql. As for compilers, the safe way is to use Visual Studio, a messy and complicated way is available for free, I documented it here: Free MSVC tools + Activestate to compile CPAN Modules
Comment on Re^3: perl -MCPAN on windows: Should I even try?