MySQL Forums
Forum List  »  Triggers

using the user() function in a trigger/replication scenario
Posted by: Steve DeWitt
Date: August 23, 2006 03:37PM

we have a trigger evalutes the user() function. We connect to the master as user A and this evaluates to A@someipaddress_hostname. When this makes it to the slave it evaluates to root@someipaddress or root@localhost. The syntax in the trigger is

if locate('A',user()) = 0 then
#do some stuff here
end if;

How can I make the trigger behave the same on the slave as it does on the master?

Options: ReplyQuote


Subject
Views
Written By
Posted
using the user() function in a trigger/replication scenario
8165
August 23, 2006 03:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.