List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:April 2 2013 5:37pm
Subject:Re: Please Help. selectcol_arrayref problem
View as plain text  
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina <gatorreina@stripped> wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
> RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
> #my $dbh = DBI->connect($dsn, $usrr, $passw);
>
> my $dbs = $dbh->selectcol_arrayref('show databases');
>
> print "@$dbs\n";
>
> When I query the server for a list of databases with the code above it
> returns the name of just two and there are over 10.
>
> Any ideas?

Permissions - the user you're logging in as probably only has
permission to see the 2 that are being returned.
Thread
Please Help. selectcol_arrayref problemRichard Reina2 Apr
  • Re: Please Help. selectcol_arrayref problemLarry Martell2 Apr
    • Re: Please Help. selectcol_arrayref problemRichard Reina2 Apr
      • Re: Please Help. selectcol_arrayref problemBenjamin Stillman2 Apr