ERROR 1044 creating a trigger in mysql on pythonanywhere

Question

I have created a database in pythonanywhere, after doing my migrations from my django project etc.. i wanted to create a trigger in my db, but the following message appears:

ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

My user does not have the permissions

If you don't have the admin privilege to set the log_bin_trust_function_creators variable, then you can't create this trigger. Find another solution to do what you were going to do without using a trigger. — Bill Karwin
– Bill Karwin, Commented Oct 11, 2019 at 16:16
is there another way to get de admin privilege?, due that I am the admin? — Uribe2304
– Uribe2304, Commented Oct 11, 2019 at 16:21
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE U SER privilege(s) for this operation another message thata apperas when a user is being created — Uribe2304
– Uribe2304, Commented Oct 11, 2019 at 16:29

Glenn · Accepted Answer · 2019-10-12 15:35:26Z

0

You cannot create triggers in MySQL on PythonAnywhere

answered Oct 12, 2019 at 15:35

Glenn

5,8362 gold badges21 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ERROR 1044 creating a trigger in mysql on pythonanywhere

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related