when doing "php artisan migrate" i got: Base table or view already exists: 1050 Table 'users'. (I am using PHPSTORM 2018.3.4)

Question

I drop the DB and then create it again. This is after i drop; (Migration & user migrated successfully)

Migration table created successfully.

In Connection.php line 664:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: 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

So the table exists when you run a migration. Check that it's actually dropped, and that you're not having multiple migrations that attempts to create the table . — Qirel
"Base table or view already exists" or "1071 Specified key was too long", which one is it? — brombeer
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists @kerbholz — Jayboy Rijovik

Ajay Namdev Ajay Namdev · Accepted Answer · 2019-03-04T06:50:59

public function boot()
{
    Schema::defaultStringLength(191);
    //
}

in provider folder find Appserviceprovider.php your boot function should be look like this and don't forget to add use Schema; at the top

when doing "php artisan migrate" i got: Base table or view already exists: 1050 Table 'users'. (I am using PHPSTORM 2018.3.4)

1 Answers