HI, I am using Perl and CGI on a public server to access a MySQL database. I have my password and username for the MySQL database included at the top of each of my Perl scripts. The password file simply initializes two variables to my username and password. The include statements in my Perl scripts point to a file called something like security.pl in ~/ . However, I just discovered that, since the apache needs to have read access to that file, the file is forced to take read permissions for the apache user. Some other user on the system, if they know the name of my file, can create a Perl script which also includes my security.pl file and reads out the contents of the username and password variables. Obviously, this is not acceptable. Since MySQL / CGI websites are very common on the internet, there must be a way secure this security.pl file. I am wondering how most people store their MySQL username and passwords. Thank you for taking the time to read this. Have a nice day, Joe

In reply to MySQL Perl Password file by JoeJaz

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.