[solved] SQLSTATE[42000]: Syntax error or access violation

that's because the defaultStringLength is not setup, you need to limit it from /app/Providers/AppServiceProvider.php
using the Schema 

so the file should looks like 

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;

class AppServiceProvider extends ServiceProvider
{
 /**
 * Register any application services.
 *
 * @return void
 */
 public function register(){
 //
 }

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

I imported the schema using use Illuminate\Support\Facades\Schema;
then added Schema::defaultStringLength(191); into the boot function
Let me know if this worked with you