Error while running default migrations

[evandojunior]

• Laravel Version: 5.4.*
• PHP Version: 7.0.14
• Database Driver & Version:
  MySQL 5.5.42

Description:

When you run the php artisan migrate command, the following error occurs:

[Illuminate\Database\QueryException]                                             
  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too l  
  ong; max key length is 767 bytes (SQL: alter table `users` add unique `users_em  
  ail_unique`(`email`)) 

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

Steps To Reproduce:

$ php artisan migrate

[RikSomers]

This has been reported several times:
#17530 #17508 #17337

It's also documented in the Migrations documentation: https://laravel.com/docs/5.4/migrations#indexes ( under Index Lengths & MySQL / MariaDB)

Adding this in your boot method of the AppServiceProvider should do the trick:

Schema::defaultStringLength(191);

like so:

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}

[evandojunior]

@RikSomers It worked, thank you!

[vinayakkulkarni]

sweet thanks @RikSomers

[RikSomers]

No problem, we're here to help eachother :)