报错一
$ php artisan migrate

Illuminate\Database\QueryException : could not find driver (SQL: select * fr
om information_schema.tables where table_schema = dev_oms and table_name = migra
tions)

at D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection.
php:664

660|         // If an exception occurs when attempting to run a query, we'll

format the error

661|         // message to include the bindings with SQL, which will make th

is exception a

662|         // lot more helpful to the developer instead of just the databa

se's errors.

663|         catch (Exception $e) {

664| throw new QueryException(

665|                 $query, $this->prepareBindings($bindings), $e
666|             );
667|         }
668|

Exception trace:

1 PDOException::("could not find driver")

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connectors

\Connector.php:68

2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=dev_oms", "root",
"root", [])

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connectors

\Connector.php:68

Please use the argument -v to see more details.
原因是php.ini 扩展"php_pdo_mysql.dll"没开启

报错二
$ php artisan migrate
Migration table created successfully.

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access
violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: a
lter table users add unique users_email_unique(email))

at D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection.
php:664

660|         // If an exception occurs when attempting to run a query, we'll

format the error

661|         // message to include the bindings with SQL, which will make th

is exception a

662|         // lot more helpful to the developer instead of just the databa

se's errors.

663|         catch (Exception $e) {

664| throw new QueryException(

665|                 $query, $this->prepareBindings($bindings), $e
666|             );
667|         }
668|

Exception trace:

1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Sp
ecified key was too long; max key length is 767 bytes")

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection

.php:458

2 PDOStatement::execute()

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection

.php:458

Please use the argument -v to see more details.
数据库编码改为utf8mb4

报错三
$ php artisan migrate
Migration table created successfully.

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access
violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: a
lter table users add unique users_email_unique(email))

at D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection.
php:664

660|         // If an exception occurs when attempting to run a query, we'll

format the error

661|         // message to include the bindings with SQL, which will make th

is exception a

662|         // lot more helpful to the developer instead of just the databa

se's errors.

663|         catch (Exception $e) {

664| throw new QueryException(

665|                 $query, $this->prepareBindings($bindings), $e
666|             );
667|         }
668|

Exception trace:

1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Sp
ecified key was too long; max key length is 767 bytes")

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection

.php:458

2 PDOStatement::execute()

  D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection

.php:458

Please use the argument -v to see more details.
加上两行代码即可

————————————————

                        版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
                    

原文链接：https://blog.csdn.net/Code_Pupil/article/details/80371145