Re: Replication and Grants nightmare

2004-04-30 Thread Nico Sabbi
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.*. > >> > >

Re: Replication and Grants nightmare

2004-04-30 Thread Paul DuBois
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 he

Re: Replication and Grants nightmare

2004-04-30 Thread Nico Sabbi
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: > > http://dev.mysql.com/doc/mysq

Re: Replication and Grants nightmare

2004-04-30 Thread Nico Sabbi
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 grant

Re: Replication and Grants nightmare

2004-04-30 Thread Paul DuBois
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 datab

Re: Replication and Grants nightmare

2004-04-30 Thread Victoria Reznichenko
Nico Sabbi <[EMAIL PROTECTED]> wrote: > > 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

Replication and Grants nightmare

2004-04-30 Thread Nico Sabbi
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 ra