Perl DBD::mysql on OS X Lion

I ran into a problem this week when the perl libraries for accessing MySQL databases refused to work on Mac OS X Lion.

The solution is

export DYLD_LIBRARY_PATH="/usr/local/mysql/lib:$DYLD_LIBRARY_PATH"

in your .bashrc