1071 Specified key was too long; max key length is 1000 bytes

[hernandohack]

I have seen the same problem in other posts right here, but none of them solve my problem.

I install the latest version of laravel.

"larave new project"

I set .env file and then.

use Illuminate \ Support \ Facades \ Schema;

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

then:

composer require spatie / laravel-permission
php artisan vendor: publish --provider = "Spatie \ Permission \ PermissionServiceProvider"
php artisan migrate

And that's when I can't go on:

.....
Migrating: 2021_03_08_052034_create_permission_tables

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `permissions` add unique `permissions_name_guard_name_unique`(`name`, 
`guard_name`))

  at F:\wamp64\www\project\vendor\laravel\framework\src\Illuminate\Database\Connection.php:678
    674▕         // If an exception occurs when attempting to run a query, we'll format the error
    675▕         // message to include the bindings with SQL, which will make this exception a
    676▕         // lot more helpful to the developer instead of just the database's errors.
    677▕         catch (Exception $e) {
  ➜ 678▕             throw new QueryException(
    679▕                 $query, $this->prepareBindings($bindings), $e
    680▕             );
    681▕         }
    682▕

  1   F:\wamp64\www\project\vendor\laravel\framework\src\Illuminate\Database\Connection.php:471
      PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")

  2   F:\wamp64\www\project\vendor\laravel\framework\src\Illuminate\Database\Connection.php:471
      PDOStatement::execute()

I use in my localhost wampp server: php 7.3.21
mysql 8.0.21

I try
php artisan optimize:clear

before to migrate, but it doesn't work either.

[drbyte]

Answered in your other post:
#1689 (comment)

Summary: Use defaultStringLength(125) if you're on MySQL 8.0. Or use MariaDB instead.

[hernandohack]

Thanks, it worked for me.