Hi,
I'm running mysql-max 4.0.18 on two servers on separate networks, master is A
and slave is B.
The problem is that if I don't grant on the master the full range of
privileges to the slave the replication doesn't even start.
Even worse is the fact that grants seems to be totally managed at
P.S. the manual doesn't say that grants super, reload, replication client and
replication slave can be used only on *.* and not on DB.*.
Each of those privileges is listed as an administrative privilege here:
http://dev.mysql.com/doc/mysql/en/Privileges_provided.html
There are not listed as
Alle Friday 30 April 2004 15:22, Victoria Reznichenko ha scritto:
Hmm..
Your queries worked fine for me:
ANT REPLICATION SLAVE, REPLICATION CLIENT, SUPER, RELOAD ON *.* TO
'replica'@'B' IDENTIFIED BY PASSWORD '715a443962d324cc'; Query OK, 0 rows
affected (0.00 sec)
mysql show grants for
Alle Friday 30 April 2004 15:51, hai scritto:
P.S. the manual doesn't say that grants super, reload, replication client
and replication slave can be used only on *.* and not on DB.*.
Each of those privileges is listed as an administrative privilege here:
At 16:22 +0200 4/30/04, Nico Sabbi wrote:
Alle Friday 30 April 2004 15:51, hai scritto:
P.S. the manual doesn't say that grants super, reload, replication client
and replication slave can be used only on *.* and not on DB.*.
Each of those privileges is listed as an administrative privilege
Alle Friday 30 April 2004 16:44, hai scritto:
At 16:22 +0200 4/30/04, Nico Sabbi wrote:
Alle Friday 30 April 2004 15:51, hai scritto:
P.S. the manual doesn't say that grants super, reload, replication
client and replication slave can be used only on *.* and not on DB.*.
Each of those