From: Date: January 5 2006 4:46pm
Subject: triggers on 5.0.17 -- definer not fully qualified
List-Archive: http://lists.mysql.com/mysql/193542
Message-Id: <43BD3F58.5070508@ebuyer.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


After upgrading to 5.0.17, the triggers on one of my instances now break 
replication with a "definer is not fully qualified" error. I set the 
DEFINER in the CREATE TRIGGER statement to CURRENT_USER (i.e., 
root@localhost), but the error still occurs. If I try setting the 
DEFINER to any other user, then I get "user does not have access" 
errors, irrespective of whether that user does or does not have the 
necessary privileges.

I've subsequently upgraded the instance to 5.0.18, but the error still 
occurs. I've also tried experimenting with setting the DEFINER as a 
specific user and then assigning INSERT, UPDATE, DELETE, SELECT and 
SUPER privileges to that user. To no avail.

Anyone have any ideas how to resolve this?

Thanks

- ian


-- 
+-------------------------------------------------------------------+
| Ian Sales                                  Database Administrator |
|                                                                   |
|                              "All your database are belong to us" |
| ebuyer                                      http://www.ebuyer.com |
+-------------------------------------------------------------------+