Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: How to connect with remote mySQL DB

by kcott (Abbot)
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


Comment on Re: How to connect with remote mySQL DB
Select or Download Code
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (10)
As of 2015-07-08 00:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls