syntax error or access violation: 1071 specified key was too long; max key length is 767 bytes

Question

Problem :

Facing migration error on Laravel 5.4 with php artisan make:auth command as follows:

syntax error or access violation: 1071 specified key was too long; max key length is 767 bytes

Answer 1

I am giving two sollutions those work for me.

1:

1. Open your database.php file insde your config dir/folder.

2. Edit your 'engine' => null, to 'engine' => 'InnoDB',

   This worked for me.

2:

1. Open your database.php file insde config dir/folder.
   2. Edit your
   'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci',
   to

   'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',

This worked for me.