'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' in aws ec2 windows server

Hi trying to host a Laravel 5.4 php web site in aws ec2 windows server-(http://3.133.59.5/) and also using bitnami-7.3 run Laravel project.I'm getting following error when run the error

Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

i tried change the config/database.php and add

            'modes'  => [
            'ONLY_FULL_GROUP_BY',
            'STRICT_TRANS_TABLES',
            'NO_ZERO_IN_DATE',
            'NO_ZERO_DATE',
            'ERROR_FOR_DIVISION_BY_ZERO',
            'NO_ENGINE_SUBSTITUTION',
        ],

but it didn't fix the this issue

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2WNJ1G7
via IFTTT