In folder config => database.php make sure mysql strict is false, like this if strict is true, make it false then clear config cash by run this command in cmd
Here is my configuration to make HTTPS working with assets. To enable this in production add REDIRECT_HTTPS=true in the .env file.
Laravel : [PDOException] SQLSTATE: Syntax error or access violation: 1231 Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO
Add below code in config/database.php