I have NO experience with Mac OS, but I do have experience with DBI and DBD::mysql. The order in which things need to be installed is this: 
  1. install MySQL database, *AND* make sure your can get
     it running and can interact with it via the "mysql"
     client.  On Red Hat Linux, the MySQL server package is
     separate from the MySQL client package - on the
     mysql server machine I usually install all the mysql
     packages there are.  For example, on my machine where
     I have MySQL up and running, I have these mysql packages
     installed:

        mysql-server-3.23.58-1.9
        mysql-devel-3.23.58-1.9
        mysql-3.23.58-1.9

     The 'mysql-3.23.58-1.9' package contains the MySQL client.

  2. make sure DBI is installed.
  3. install DBD::mysql

[download]
DBD::mysql requires that MySQL already be installed. The error you got 
   Failed to determine directory of libmysqlclient.a|libmysqlclient.so
+. Use

  perl Makefile.PL "--libs=-L<dir> -lmysqlclient"

[download]
indicates that it can't locate the MySQL client ("libmysqlclient.so") library. So I believe you need to find the MySQL packages for Mac OS and install those, and get mysql working. Then move on to install DBI (if not already installed) and DBD::mysql.

HTH.

In reply to Re: Problem with setting locations in Makefile.PL by hmerrill
in thread Problem with setting locations in Makefile.PL by bradcathey

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.