Answered my own question, sorry for the quick posting...
When I was trying to do the "LOAD DATA FROM MASTER", with the master set as "GRANT ALL ON *.* TO 'repl_user'@ ..." the slaves were reporting an error that stated I needed to "GRANT SUPER,REPLICATION CLIENT" on the master, which didn't work.
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE" for the master, and a "LOAD DATA" worked just fine.
-id
ian douglas wrote:
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]
