perl: symbol lookup error undefined symbol: mysql_init

[arn]

Hi,

When I am trying the below perl scrip, I am getting the "perl:symbol lookup error". It looks if I modify the PATH currently I could have resolve the issue. But I am not sure what lib I should bring to the PATH. Please let me know how do I resolve this and feel free to share if you have any different solutions or workarounds to this issue.

[root@localhost]# ./create_defs.pl --user root --password amma --db=d1 --table=tbl1
perl: symbol lookup error: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

[root@localhost]# ll /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so
-r-xr-xr-x 1 root root 333965 Sep 12 13:05 /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so

[root@localhost]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/mysql/bin:/root/bin

Thank you!