SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL)

Hello, good morning guys! Nice to meet you again. How are you today? Hahaha, I'm okay.

Today I want to tell my experience when I use migration at laravel 5.6. There is some error when I make an migration with my new table. In this case this table is 'produk'. I was complete for make function up and down. But when I run 'php artisan migrate' there is an error.

Liki this...

C:\xampp1\htdocs\blog>php artisan migrate

In Connection.php line 664:

  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQ

  L: alter table `users` add unique `users_email_unique`(`email`))

In Connection.php line 458:

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

Okay, don't worry about this problem. It just at Laravel 5.4 you must declarate how long your String tipe data. Okey let's follow the tutorial.

1. First follow my instagram account at @muhnandajr and @gonesinau.
   
2. Second import Schema at your 'AppServiceProvider' file in the '/app/Providers' folder.
   use Illuminate\Support\Facades\Schema;
   
3. Third, choose how long your string tipe data at function 'boot'
   Schema::defaultStringLength(191);
   
4. And, that's all. Please type an 'php artisan migrate' and the proble was solved.
   

Okey guys, I think enough for this case. See you on the next tutorial.