One master, two slaves, mysql 4.1.7 installed via compiled source code, on RedHat 8.0

On the master system I did this:

grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1' identified by 'repl_passwd' ;
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2' identified by 'repl_passwd' ;



and on the two slaves:

CHANGE MASTER TO MASTER_HOST='master.db.hostname', MASTER_PORT=3306, MASTER_USER='repl_user', MASTER_PASSWORD='repl_passwd' ;

... as per the documentation.


On the slaves, the command:

LOAD DATA FROM MASTER

responds with

ERROR 1218 (08S01): Error connecting to master: Access denied for user 'repl_user'@'known.hostname1' (using password: YES)
or
ERROR 1218 (08S01): Error connecting to master: Access denied for user 'repl_user'@'known.hostname2' (using password: YES)



Any tips?

/etc/my.cnf on the master sets the server-id to 1, the slaves are 2 and 3 respectively

-id


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to