Not Compatible with MySQL 8.0

[wyattjoe40]

See discussion here: laravel/framework#23948 . The provided workaround (adding "modes" array to MySQL config) seems to have fixed the problem.

When running this command you get the error below.

php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' (SQL: select * from information_schema.tables where table_schema
= sampledb and table_name = migrations)

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

MySQL version: mysql Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)
PHP version: PHP 7.2.9 (cli) (built: Aug 15 2018 23:10:01) ( ZTS MSVC15 (Visual C++ 2017) x64 )