DBD::mysql help

[Jonathan Baumgartner]

I am unable to install DBD::mysql via CPAN successfully. Every time I try, I get errors like this:

CPAN.pm: Going to build J/JW/JWIED/DBD-mysql-2.1020.tar.gz

Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.

[Repeated 8 times. Followed by:]

I will use the following settings for compiling and testing:

cflags (guessed) = -I/usr/local/mysql/include
libs (guessed) = -L/usr/local/mysql/lib -lmysqlclient -lz -lgz
nocatchstderr (default) = 0
ssl (guessed) = 0
testdb (default) = test
testhost (default) =
testpassword (default) =
testuser (default) =

Then when make test is executed, everything fails, with errors like this:

t/10dsnlist.........DBI->connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/10dsnlist.........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay

mysql is running, but root has a password associated with it. I imagine this is why the tests are failing. How do I get around this?

thanks,
jon