G'day mcfarnell,

Welcome to the Monastery.

You've put your code within <code>...</code> tags; which is good. Please do the same for data, program output, and error/warning messages. That way, we can see exactly what you're seeing.

After commenting out line 30, the real output would have been: 

Perl MySQL Connect Demo
Connected to the MySQL database.

[download]

I don't know what the real output associated with "500 internal server error" is because you don't show it. This is an important piece of information which you should always provide when asking for help.

From the code you show, you've almost certainly got a problem with the format of $DSN. See the various formats shown for DBD::mysql: connect().

You also have potential problems with one or more of the interpolated, double-quoted strings that you've shown as "***". Passwords in particular often contain special characters: "pass$word", for instance, will evaluate as the literal string 'pass' concatenated with the value of the variable $word.

— Ken

In reply to Re: 500 internal server error when connecting to mysql database by kcott
in thread 500 internal server error when connecting to mysql database by mcfarnell

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.