Access violation error in Laravel 5.4 migration
Posted onWhen we setup a fresh laravel 5.4 and tried to run default user tables migration
1 |
php artisan migrate |
then we got a below error
1 2 3 |
[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 `users` add unique `users_email_ unique`(`email`)) |
After searching for this error in google, we came to know that it is due to mysql database engine updation. There are few solutions recommended in few places. We tried them but […]