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.

Perl 6 - the future is here, just unevenly distributed

Replies are listed 'Best First'.
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.

[reply]
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?

[reply]
[reply]

In Section Seekers of Perl Wisdom