ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation - on AWS Lightsail Mysql DB

Asked Mar 08 '20 at 23:12

Active Mar 08 '20 at 23:25

Viewed 826 times

I restored an AWS Lightsail DB (HA) from an emergency restore - and now I can't create functions or drop triggers, etc, when logged in as dbmasteruser - I receive this message:

Error Code: 1419. 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)

I've tried the console statement: SET GLOBAL log_bin_trust_function_creators = 1; but get the access denied message.

Has anybody seen this before and know how to fix it? Much obliged.

edited Mar 08 '20 at 23:25

Bashir

2,057
5
19
44

asked Mar 08 '20 at 23:12

Simon Stapleton

Have you considered granting the super privilege to dbmasteruser: https://stackoverflow.com/questions/11946012/how-to-add-super-privileges-to-mysql-database – Honeyboy Wilson Mar 08 '20 at 23:50

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation - on AWS Lightsail Mysql DB

0 Answers0