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 replica@'B'; > +-------------------------------------------------------------------------- >----------------------------------------------------+ > > | Grants for [EMAIL PROTECTED] > | | > > +-------------------------------------------------------------------------- >----------------------------------------------------+ > > | GRANT RELOAD, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO > | 'replica'@'B' IDENTIFIED BY PASSWORD '715a443962d324cc' | > > +-------------------------------------------------------------------------- >----------------------------------------------------+ 1 row in set (0.01 > sec) > > mysql> revoke ALL PRIVILEGES ON *.* FROM replica@'B'; > Query OK, 0 rows affected (0.00 sec) > > mysql> flush privileges; > Query OK, 0 rows affected (0.00 sec) > > mysql> show grants for replica@'B'; > +-------------------------------------------------------------------------- >-----+ > > | Grants for [EMAIL PROTECTED] > | | > > +-------------------------------------------------------------------------- >-----+ > > | GRANT USAGE ON *.* TO 'replica'@'B' IDENTIFIED BY PASSWORD > | '715a443962d324cc' | > > +-------------------------------------------------------------------------- >-----+ 1 row in set (0.00 sec) > > Did you have account for 'replica'@'B' before?
neither other users with the same name nor other entries for the same host > Are the above queries exact that you used? yes, except the host names > Which OS do you use? > the master is a Redhat 7.3 with Mysql-max 4.0.18 (binary rpms from www.mysql.com), the slave is a very old Cobalt 6.0 with Mysql-max 4.0.18 compiled from the .src.rpm. Thanks for your help > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]