Hello everyone,
I’ve gone through the MySQL documentation, but apparently i am not smart enough.
Our environment is based on a MySQL Binlog replication with Oracle MySQL 8.0.40. When trying to create a trigger, I consistently receive the “ERROR 1419” error.
The test user has been granted all privileges on the test database.
As a quick fix, we’ve enabled the “log_bin_trust_function_creators” option, but due to its deprecation, we’re seeking a future-proof solution. Since SUPER privileges are also deprecated, they’re not an option either.
I’d be very grateful for any suggestions.
Thank you in advance, and have a great day!