Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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 (Deacon) 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 wandering the Monastery: (10)
As of 2014-07-25 07:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (169 votes), past polls