Last active
May 31, 2018 00:03
-
-
Save ucan-lab/07a2f332828c80b381b7517d79e8f51b to your computer and use it in GitHub Desktop.
Laravel5 MySQL8.0 NO_AUTO_CREATE_USERのSQL_MODEエラー対策 ref: https://qiita.com/ucan-lab/items/2a482a9537dcc5daeb97
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ php artisan migrate | |
| In Connection.php line 664: | |
| SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' (SQL: sel | |
| ect * from information_schema.tables where table_schema = microposts and table_name = migrations) | |
| In MySqlConnector.php line 150: | |
| SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 'mysql' => [ | |
| 'strict' => false, | |
| ], |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment