laravel: Illuminate\Database\Que

使用mysql版本为8.0

使用php artisan migrate命令提示Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

image.png

解决

1 修改\app\Providers下面AppServiceProvider.php

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

如果报错,头部添加use Illuminate\Support\Facades\Schema;

image.png
2 修改/config/database.php

'engine' => null'改成 
'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',

3 清空缓存

php artisan cache:clear
php artisan config:clear

4 在执行php artisan migrate

搞定

---

---

---

本人有份laravel5.8教学课程，需要的同学可以关注公众号：小贝壳的资源库恢复laravel获取

小贝壳的资源库