You all know the feeling you get when having a debugging issue, it's tiring. This will be the second real time I will be experiencing this error.

I have tried some solutions which didn't work like "php artisan migrate:fresh", "php artisan migrate:refresh"........none didn't work.

What I did was , I went to App-> Providers->AppServiceProvider.php I inputted "Use Illuminate\Support\Facades\Schema;" under a similar trend, then I added "Schema::defaultStringLength(150);". Then I went to my database in mysql and deleted all the tables, I ran "php artisan migrate" again. Migration success!!!