How to change MySQL mode permanently in MySQL Managed Database?

I came across this solution online by Nathaniel Hammond: https://gist.github.com/nfourtythree

The implementation is swift and takes just a couple of seconds or minutes:

1. Log into your server as root
2. Get script wget https://gist.githubusercontent.com/nfourtythree/90fb8ef5eeafdf478f522720314c60bd/raw/disable-strict-mode.sh
3. Make is executable chmod +x disable-strict-mode.sh
4. Run the script ./disable-strict-mode.sh

You can keep the script where you downloaded it for future mods or references or you can rm -rf disable-strict-mode.sh and delete the shell script.

You will then have MySQL 5.7 without strict mode.

DISCLAIMER: Not sure if it works with version 8.0

It would be nice if DO could make it tweakable so we don’t need to create a ticket for this every time we spin a new Managed DB

I found the work around. Just simply put mode change query first when you connected to database. mean that every connection have to change mode before you do things. I know it is not good solution but it help me out for now.