How to install 'MySQL' driver on Solaris platform:

How to install 'MySQL' driver on Solaris platform:
-------------------------------------------------

STEP 1:

Download DBD-mysql-4.007.tar.gz
http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm
by using wget tool from unix10/unix22 boxes because ftp/telnet/scp/sftp
is prohibited.

STEP 2:

Copy this file into /tmp/mysql ( Create a temporary directory mysql under /tmp )

STEP 3:

gzip -d DBD-mysql-4.007.tar.gz

STEP 4:

tar xvf DBD-mysql-4.007.tar

STEP 5:

cd DBD-mysql-4.007


STEP 6:
(This can vary depending upon where mysql libraries and header files are)
perl Makefile.PL --libs="-L/usr/local/mysql/lib/mysql -lmysqlclient -lz" \
--cflags=-I/usr/local/mysql/include/mysql

STEP 7:

make
make install


STEP 8: mysql driver has been installed if 'make install' does not produce any errors.




STEP 9: How to verify if - mysql driver is installed.

Used this perl script to verify:

#!/opt/local/bin/perl -w

use strict;
use DBI;

$|=1;
my @x_drivers = DBI->available_drivers();
foreach (@x_drivers){ print $_ . "\n";}

__END__