I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell <larry.mart...@gmail.com>
> 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.
>
