AWS MySQL 5.7

[yossicoh]

I use mySql 5.7 and I tried to do all the necessary actions in order to run the commands and I get the error:

[gh-ost]# bin/gh-ost --user=**** --password=**** --host=**** --switch-to-rbr --database=cust4 --table=RB --alter="ALTER TABLE RB ADD TYPE1_ID BIGINT;" --debug --chunk-size=2000 --max-load=Threads_connected=20
2023-09-14 10:56:08 INFO starting gh-ost 0a033c7
2023-09-14 10:56:08 INFO Migrating cust4.RB
2023-09-14 10:56:08 INFO inspector connection validated on **:PORT
2023-09-14 10:56:08 INFO User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on cust4.
2023-09-14 10:56:08 INFO RDS:3306 has MIXED binlog_format. I will change it to ROW, and will NOT change it back, even in the event of failure.
2023-09-14 10:56:08 INFO binary logs validated on RDS:3306
2023-09-14 10:56:08 ERROR Error 1227: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
2023-09-14 10:56:08 INFO Tearing down inspector
2023-09-14 10:56:08 FATAL Error 1227: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

[dbadmin-irl]

Try setting binlog_format to "row" in your db instance parameter group.

[edusantana]

For me, using on RDS, after I changed the format I had to reboot the database too.