Hi
What is the best practise to stop and start replication on a 3 way replication 2 masters 1 slave i need to change the access to the servers the last time someone tried the replication failed so i want to stop the replication
first before i change it or is there another way i can change the access for root without breaking the replication
this is the error i got when we first tried to change the root access
Quote:
[ERROR] Slave: Error 'There is no 'root'@'%' registered' on query. Default database: 'office'. Query: 'CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `view1` AS select _latin1'no' AS `1`,_latin1'yes' AS `2`,(select `func1`(5) AS `func1(5)`) AS `3`', Error_code: 1449
[ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000051' position 564677915
|