DBD-mysql installed ,but still error “install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC”

Question

Install information:

Using DBI 1.608 (for perl 5.008009 on x86_64-linux) installed in /usr/local/lib/perl5/site_perl/5.8.9/x86_64-linux/auto/DBI/

Error information:

[root@datacenterETL DBD-mysql-4.020]# perl ../testConnect.pl install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.9/x86_64-linux /usr/local/lib/perl5/5.8.9 /usr/local/lib/perl5/site_perl/5.8.9/x86_64-linux /usr/local/lib/perl5/site_perl/5.8.9 .) at (eval 3) line 3.

Maybe the DBD::mysql Perl module has not been installed completely, or maybe the capitalisation of 'mysql' is not right.

Answer 1

It seems like you are using Linux OS. In this case, you would find it easier to install a pre-packaged version of the module.

On a Red Hat, derivative try:

yum install perl-DBD-mysql

On a Debian, derivative try:

apt-get install libdbd-mysql-perl

Join the SQL Course fast, to Learn SQL concepts in detail and get certified.