Everything required to get Bundle::DBI and DBD::mysql installed in OS X 10.4 "Tiger"
This article assumes you already have MySQL installed and functioning properly.
The version used in this instance was mysql-standard-5.0.15-osx10.4-powerpc. Please note:
The versions of DBD & DBI described here are no longer current - however - the process does work fine with the current versions.

I started off with the helpful info found on the following two pages, but I had to do more to get it working:

http://www.gyford.com/phil/writing/2004/06/07/installing_dbi_a.php
http://www.truerwords.net/articles/osx/install_dbd_mysql.html

As noted above, mysql-standard-5.0.15-osx10.4-powerpc is in use,
downloaded and configured according to the MySQL site instructions.
If you are using an earlier version of MySQL, then you will need to adjust accordingly. The articles I link to above, may work for you verbatim.

1. Download DBI 1.51 from CPAN
2. Unpack the file, eg: tar -xzvf DBI-1.51.tar.gz
3. cd into the directory
4. Type perl Makefile.PL
5. Type make && make test
6. sudo make install (NB: See below !)
7. IMPORTANT: to get DBD to install, you may need to specify the location of your mysql_config file (the following should all be on one line):

perl Makefile.PL --testdb=test --testuser=nameused --testpassword=actualpasswdused --testhost=localhost --mysql_config=/usr/local/mysql/bin/mysql_config

If something goes wrong, backup by typing: make clean

(You will of course need to have setup a "test" mysql database with appropriate privileges for your "test" user)

8. Install DBI now, via: sudo make install

9. Download DBD::mysql 3.0006 from CPAN
10. unpack the archive & cd into it
11. perl Makefile.PL --testdb=test --testuser=nameused --testpassword=actualpwdused --testhost=localhost
12. make && make test
13. sudo make install

 

If all of this gives you a headache, and you have some web-based software you "just want to get running !", then call and setup an appointment, and we'll make it happen.