Laravel 出现Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'解决办法

Song • 1192 次浏览 • 0个评论 • 2021年10月20日

laravel运行程序报错

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

如何解决？

进入config\database.php把mysql配置'strict' => true,把strict改为false

'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'test'),
    'username' => env('DB_USERNAME', 'root'),
    'password' => env('DB_PASSWORD', '123456'),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => true,
    'engine' => null,
],

以上操作完成之后即可