调用触发器的 MySQL 用户没有 database2.customers 表的 INSERT 权限。用户仅对存储 clients 表的主数据库具有权限。
触发器中执行的 SQL 语句中的错误会导致生成触发器的操作失败。
在 MySQL 用户被授予对 database2 中的表的 INSERT 权限后，错误停止并且问题得到解决。
Summary of the comment thread above: that the origin of the error was this:
Syntax error or access violation
The MySQL user calling the trigger does not have INSERT privilege to the database2.customers table. The user only had privileges on the primary database, where the clients table was stored.
An error in an SQL statement executed in a trigger causes the action that spawned the trigger to fail.
After the MySQL user was granted INSERT privilege to tables in database2, the errors stopped and the issue was resolved.
发布评论
评论（1）
上面的评论线程摘要：错误的根源是这样的：
调用触发器的 MySQL 用户没有
database2.customers表的 INSERT 权限。用户仅对存储clients表的主数据库具有权限。触发器中执行的 SQL 语句中的错误会导致生成触发器的操作失败。
在 MySQL 用户被授予对
database2中的表的 INSERT 权限后，错误停止并且问题得到解决。Summary of the comment thread above: that the origin of the error was this:
The MySQL user calling the trigger does not have INSERT privilege to the
database2.customerstable. The user only had privileges on the primary database, where theclientstable was stored.An error in an SQL statement executed in a trigger causes the action that spawned the trigger to fail.
After the MySQL user was granted INSERT privilege to tables in
database2, the errors stopped and the issue was resolved.