DBD-Mysql (need to spcify a raft of options on the command line) It took a while to get these right as it can't find the required libs and includes without help.

[root@devel3 DBD-mysql-2.9002]# perl Makefile.PL  --cflags=-I'/usr/local/mysql/include/'  --libs=-L'/usr/local/mysql/lib/ -lmysqlclient -lz' --testdb=test --testuser=root --testpassword=xxxxxxxxx --testhost=localhost

I will use the following settings for compiling and testing:

  cflags        (Users choice) = -I/usr/local/mysql/include/
  libs          (Users choice) = -L/usr/local/mysql/lib/ -lmysqlclient -lz
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (Users choice) = test
  testhost      (Users choice) = localhost
  testpassword  (Users choice) = xxxxxxxxxx
  testuser      (Users choice) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.21 installed in /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
Writing Makefile for DBD::mysql
[root@devel3 DBD-mysql-2.9002]# make
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI -I/usr/local/mysql/include/ -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686   -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/CORE  dbdimp.c
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI -I/usr/local/mysql/include/ -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686   -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/CORE  mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/mysql/lib:/usr/lib" /usr/bin/perl myld gcc  -shared -L/usr/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so   -L/usr/local/mysql/lib/ -lmysqlclient -lz  
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
Manifying blib/man3/Mysql.3pm
[root@devel3 DBD-mysql-2.9002]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/i386-linux -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base...........ok                                                        
t/10dsnlist........ok                                                        
t/20createdrop.....ok                                                        
t/30insertfetch....ok                                                        
t/40bindparam......ok                                                        
t/40blobs..........ok                                                        
t/40listfields.....ok                                                        
t/40nulls..........ok                                                        
t/40numrows........ok                                                        
t/50chopblanks.....ok                                                        
t/50commit.........ok                                                        
        14/30 skipped: No transactions
t/60leaks..........skipped
        all skipped: no reason given
t/ak-dbd...........ok                                                        
t/akmisc...........ok                                                        
t/dbdadmin.........ok 6/21New DB not in DSN list                             
t/dbdadmin.........ok 10/21DSN testab not in DSN list.                       
t/dbdadmin.........ok 14/21DSN testac not in DSN list.                       
t/dbdadmin.........FAILED tests 7, 11, 15                                    
        Failed 3/21 tests, 85.71% okay
t/insertid.........ok                                                        
t/mysql2...........ok                                                        
t/mysql............ok                                                        
Failed Test  Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/dbdadmin.t               21    3  14.29%  7 11 15
1 test and 14 subtests skipped.
Failed 1/18 test scripts, 94.44% okay. 3/759 subtests failed, 99.60% okay.
make: *** [test_dynamic] Error 11
[root@devel3 DBD-mysql-2.9002]#


You will not get any compile errors or warnings if you get the libs and includes right. Note the 3 test ‘failures’ are not important.