I'm trying to use CPAN to install DBD:mysql under Mac OS X 10.3. I've made the 'env' changes to config.pm in perl 5.8.1, but I'm finding now that, while DBD:mysql downloads and appears to compile fine, all tests fail because the user root with password NO doesn't have access to my mysql server. Can anyone advise me how/where to fix this? This is my first use of CPAN and first attempt to install mysql, so it's entirely probable that I'm missing the blindingly obvious!
thanks Richard