laravel5.4版migrate出現的錯

[Illuminate\Database\QueryException]
SQLSTATE[42000]: 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))

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

出現上述錯誤

是因為mysql在5.7.7之前

只要改

「AppServiceProvider.php」 文件，在 function boot 内增加

use Illuminate\Support\Facades\Schema;

public function boot()
{
Schema::defaultStringLength(191);
}

即可

https://news.laravel-china.org/posts/544