Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: Connect to MySQL database (on Ubuntu Server) using Perl

by liverpaul (Novice)
on Jul 25, 2012 at 12:38 UTC ( #983647=note: print w/ replies, xml ) Need Help??


in reply to Re: Connect to MySQL database (on Ubuntu Server) using Perl
in thread Connect to MySQL database (on Ubuntu Server) using Perl

Hi,

Thanks for the reply. I've changed my code to this:

#!/usr/bin/perl use strict; use warnings; use DBI; my $username='username'; my $pass='password'; my $db='database_name'; my $host='hostname'; my $dbh = DBI->connect( "dbi:mysql:database=$db:$host", $username, $pa +ss, { 'PrintError' => 1, 'RaiseError' => 1 } );

I'm still getting an error: Unknown MySQL server host 'hostname' (2) at ...


Comment on Re^2: Connect to MySQL database (on Ubuntu Server) using Perl
Download Code
Re^3: Connect to MySQL database (on Ubuntu Server) using Perl
by moritz (Cardinal) on Jul 25, 2012 at 12:45 UTC

      I just used hostname for my privacy. I used the real hostname in my script.

      When I was setting up my server (for my first time) I gave it a hostname (that's the name I tried in my script). I haven't done all the dns stuff yet. I've tested the site just using the ip address (I've also tested this as my hostname).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://983647]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (10)
As of 2014-07-28 11:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (196 votes), past polls