1laravel 报错解决方案Specified key was too long;

1phphub

 

//Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))

'mysql' => [

    'driver'    => 'mysql',

    'host'      => env('DB_HOST', 'localhost'),

    'database'  => env('DB_DATABASE', 'forge'),

    'username'  => env('DB_USERNAME', 'forge'),

    'password'  => env('DB_PASSWORD', ''),

    'charset'   => 'utf8',    'charset'   => 'utf8', // changed

            'collation' => 'utf8_unicode_ci', // changed

    'collation' => 'utf8_unicode_ci',  

    'prefix'    => '',

    'strict'    => false,

],

 

 

 

2

composer install

npm install

 gulp

 gulp watch