Illuminate\Database\QueryExcepti

安装laravel-admin时报错

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

解决方法：

可以在 AppServiceProvider.php 文件(此文件在app/Providers/下)里的 boot 方法里设置一个默认值（斜体代码）：

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

use Illuminate\Support\Facades\Schema;

class AppServiceProvider extends ServiceProvider{

    /**   

      * Bootstrap any application services.   

      *   

      *@returnvoid   

      */   

        public function boot()

        {

            Schema::defaultStringLength(191);

        }

    /**   

      * Register any application services.   

      *   

      *@returnvoid   

      */   

        public function register()

        {

           //

        }

}