RE: help needed for replication : EUREKA
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
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
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
Win32 - replication - Error 1133
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
Win32 - replication - Error 1133
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