Hi Sergei,
I can't think of anything else, but I would suggest checking the output of SHOW INNODB
STATUS for clues, just in case the foreign key is causing an odd error message. I
would not be surprised, as InnoDB FK error messages are sometimes hard to understand.
Cheers
Baron
Sergei wrote
Hello,
Thanks for the answer!
I checked the thing you suggested:
1) output of SHOW GRANT is correct
2) the problematic table is not a view
3) no triggers - only foreign key constraint. "ADD CONSTRAINT
`mydb2_table2_ibfk_1` FOREIGN KEY (`table2_user_id`) REFERENCES `table1`
(`usr_id`) ON DELETE
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been granted by this quer
