You may wish to look into where $user and $pass come from in your script, since it appears that the values being used do not have the correct permissions to access the database.

Give it a look-see, and determine if your script is running as the correct user (you may have to look at both the script and the httpd.conf file), and/or whether or not your script is pulling the correct values to be used in the connect string. Also, ensure that the user and password values being sent are permitted in the database.

Hope that helped,
-v
"Perl. There is no substitute."

In reply to Re: DBI, DBD::MySQL, Apache & Cygwin by Velaki
in thread DBI, DBD::MySQL, Apache & Cygwin by rvosa

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.