Are any of you pair.com users? I am having problems getting my site moved over to them as I'm used to using Cpanel. I created a database and it gave me the login information for it.

This is the connection code I've always used in the past and it works, but it won't here. They did tell me a server address though but from my original code, I don't know where to include it. 


use DBI;

###################
# configurations
###################
my $dbase = "111";
my $mysql_user = "222";
my $mysql_pass = "333";

###################
print header;

my $dbh = DBI->connect("DBI:mysql:$dbase", $mysql_user, $mysql_pass) o
+r
print DBI->errstr;

print "We are connected.<br>";

[download]
It said Database Server: db71b.pair.com. This is probably why it's not connecting. Can someone help me add that to the code or is anyone familiar with how to use their databases?

By the way, I did send them an email but it'll be a couple days until they get back to me probably.

I appreciate any help at all that you can give me.

In reply to How to connect to MySQL on pair.com by Anonymous Monk

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.