Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: How to connect with remote mySQL DB

by kcott (Canon)
on Aug 16, 2012 at 09:40 UTC ( #987719=note: print w/replies, xml ) Need Help??


in reply to How to connect with remote mySQL DB

DBD::mSQL shows the syntax in the first few lines of the SYNOPSIS.

Update: Your code shows mSQL but I notice your node title shows mySQL. You'll need to resolve that ambiguity. DBD::mSQL has the syntax for both but DBD::mysql may be more appropriate for you.

-- Ken

Replies are listed 'Best First'.
Re^2: How to connect with remote mySQL DB
by pvaldes (Chaplain) on Aug 16, 2012 at 10:03 UTC

    I see now...

    Ken is right, yes, the real problem is that the line is malformed so the passed driver's name is really mSQL//www.db4free, instead mSQL trying to connect to "http://www.db4free". Try with:

    #!/usr/bin/perl -w use DBI; my $dbh = DBI->connect("dbi:mysql:dbname=aghpisos;host=www.db4free","s +adecki", "***");

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://987719]
help
Chatterbox?
[Corion]: Another spam comment :-/

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2017-02-24 11:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (354 votes). Check out past polls.