On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina <gatorre...@gmail.com> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql