Can't Install DBD::mysql

Trying to install this module but it fails with the following fail 
message at the end:

Failed 26/28 test scripts. 423/426 subtests failed.
Files=28, Tests=426, 10 wallclock secs ( 6.13 cusr +  1.20 csys =  7.33
CPU)
Failed 26/28 test programs. 423/426 subtests failed.
make: *** [test_dynamic] Error 255
  CAPTTOFU/DBD-mysql-4.005.tar.gz
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
Failed during this command:
 CAPTTOFU/DBD-mysql-4.005.tar.gz              : make_test NO


The first failed test error message is:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" 
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............ok 1/5install_driver(mysql) failed: Can't load 
'/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/blib/arch/auto/DBD/mysql/mysql.bundle'

for module DBD::mysql: 
dlopen(/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/blib/arch/auto/DBD/mysql/mysql.bundle,

2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: 
/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at 
/System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 
230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
t/00base.............dubious                                              
  

        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay

What should i do next?

-- 
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume
| Blog at http://www.lolajl.net/blog/
"In rivers, the water that you touch is the last of what has passed
and the first of that which comes; so with present time." 
- Leonardo da Vinci (1452-1519)