Fletch is right. Even if root can only connect over local host you still have given away way too much information. Also, you should always create underpriviledged users to run programs -- allowing programs / whatever the least privilege possible is a very important programming concept. So create a database and a user (with a password that you don't display on Perlmonks) and use them to connet to the database. Also assign root a password. Do the following in case you don't want to look up the commands (assuming you're using mysql):

% mysql -u root users mysql> UPDATE users SET password = mysql> password('secretpassword') WHERE User = "root"; mysql> GRANT ALL PRIVILEGES ON yourdatabase.* mysql> TO 'underpriviledgeduser'@'hostname'; mysql> UPDATE users SET password = mysql> password('anothersecretpassword') WHERE mysql> User = "underpriviledgeduser"; mysql> FLUSH PRIVILEGES;

I would strongly suggest you don't allow connections from anywhere but localhost. (i.e. use localhost or 127.0.0.1 as your hostname). If you really didn't release your password and deleted it (i.e. the "" was intentional), apologies. However, I figured it's better safe then sorry, so best to give you the information just in case.


Want to support the EFF and FSF buy buying cool stuff? Click here.

In reply to Re: meta sugguestion by Vautrin
in thread Print and Die! by Nik

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.