Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: DBD mysql can't detect mysql installation

by moritz (Cardinal)
on Jul 06, 2012 at 09:42 UTC ( #980234=note: print w/ replies, xml ) Need Help??


in reply to DBD mysql can't detect mysql installation

That's OK. You can connect to your mysql database with DBI->connect(...) even though your databases aren't shown as "known data sources".

The background is that the mysql driver doesn't know which database to connect to (there could be multiple running on your machine, or none at all, and access happens over the network), and which username and password to use.

You can also see that only file-based DBD modules list known data sources, because all the others have the same problems as the mysql driver.


Comment on Re: DBD mysql can't detect mysql installation
Download Code
Re^2: DBD mysql can't detect mysql installation
by nitin1704 (Sexton) on Jul 09, 2012 at 05:55 UTC

    Thanks Moritz. I tried querying the database and it works. BTW, is Access really a file based DB?

Re^2: DBD mysql can't detect mysql installation
by mje (Curate) on Jul 09, 2012 at 08:45 UTC
    You can also see that only file-based DBD modules list known data sources, because all the others have the same problems as the mysql driver.

    That is not strictly true. Although the ODBC ones listed are file based in this example the real reason they are listed is because DBD::ODBC's datasources method can query the ODBC Driver Manager for the data sources. If the OP had had a data source for MS SQL Server or Oracle they would have been listed as well.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2014-11-27 23:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (190 votes), past polls