"Relocation error"

[Rich DeSimone]

Ok I am fairly new to perl and perl DBI so please bear with me.

I thought I set everything up right .. I did:

perl -MCPAN -e 'install DBI'
perl -MCPAN -e 'install DBD::mysql'

That went ok, so I found some basic code to test it out..

#!/usr/bin/perl -w

use DBI;

my $dsn = 'DBI:mysql:test:localhost';
my $db_user_name = 'root';
my $db_password = 'xxxxxx';

my $dbh = DBI->connect($dsn, $db_user_name, $db_password);


$dbh->disconnect();
-------------------

So I am assuming that code is right and I don't think it is even relevant to my 
problem.  When I try to run the script I get "perl: relocation error: 
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined 
symbol: mysql_init"

Anyone know what the problem is and a possible solution?

Thanks,
Rich