The solution is ... FLUSH PRIVILEGES; on the slaves. As it's not an UPDATE, this command is not sent to slaves with the binlog. > -----Original Message----- > From: BALU Frédéric [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 8:47 AM > To: 'Stefan Hinz'; [EMAIL PROTECTED] > Subject: RE: help needed for replication > > > Already tried ... Not successfully. > Another idea ? > > > -----Original Message----- > > From: Stefan Hinz [mailto:[EMAIL PROTECTED]] > > Sent: Friday, July 20, 2001 7:51 PM > > To: BALU Frédéric; [EMAIL PROTECTED] > > Subject: Re: help needed for replication > > > > > > Dear Frederic, > > > > > localhost | jkasas | 1896f443280395b3 > > > And what I do and get : > > > mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; > > > ERROR 1133: Can't find any matching row in the user table > > > > Try GRANT SELECT ON MEMBERS.users TO jkasas@localhost (w/out > > quotes)! :) > > > > Regards, > > > > -- > > Stefan Hinz > > Geschäftsführer / CEO iConnect e-commerce solutions GmbH > > # www.js-webShop.com www.iConnect.de > > # Gustav-Meyer-Allee 25, 13355 Berlin > > # Tel: +49-30-46307-382 Fax: +49-30-46307-388 > > > > ----- Original Message ----- > > From: "BALU Frédéric" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, July 20, 2001 5:54 PM > > Subject: help needed for replication > > > > > > > Hi everybody, > > > > > > I use Replication on a windows NT4 Server. > > > There are 1 master and 2 slaves, all on the same machine. > > > One slave is started with the option skip-name-resolve, not the > > other. > > > For the 2 slaves : master-host=localhost > > > When adding a user (MYSQL.User), the replication is OK but, > > > when I use GRANT, I get a 1133 error. > > > Let's have a look on a slave : > > > > > > MYSQL.User table : > > > localhost | jkasas | 1896f443280395b3 > > > And what I do and get : > > > mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; > > > ERROR 1133: Can't find any matching row in the user table > > > > > > Personnally, I don't understand why. > > > Does anyone understand ? > > > > > > Thx for the answers. > > > > > > -- > > > Frederic BALU > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php