Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, "Richard Reina" wrote:
>I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina 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 =
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
> On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina
> wrote:
> > use DBI;
> > my $dbh = DBI->conn
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_arrayr
