|
|||||||||||
|
Replication breaks w/o explanation
From: Jesse <jlc(at)msdlg.com>
Date: Mon Oct 08 2007 - 08:02:23 EDT
use `tsa`; DO `AddSchool`(_latin1'Easy High School',_latin1'2',_binary'0',1) My question is this. When a slave is executing commands from the binlog on the master, what user does it use? Does it use the original user that was used, does it use the root user, or the Replication user? Or does it by-pass the user process all together, and simply executes the commands? If it's the replication user, I may see my problem. Strange, though, that updates and inserts seem to work, but executing functions doesn't, when I haven't granted any rights to the replication user on the slave at all, and I only granted replication rights to it on the master. In fact, when I added the user, I used the server's name as the "host" designation, so it would appear that in MySQL Administrator, I can't assign rights to it. Maybe I can in the command prompt, but I haven't tried that yet. Am I on the right track here, or does anyone else have any ideas?
Thanks,
-- MySQL Replication Mailing List For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/replication?unsub=lists@pantek.comReceived on Mon Oct 8 08:02:53 2007 This archive was generated by hypermail 2.1.8 : Fri Jul 04 2008 - 00:24:03 EDT |
||||||||||
|
|||||||||||