laravel执行php artisan migrate报错的解决方法分享！

报错一

  $ php artisan migrate      IlluminateDatabaseQueryException : could not find driver (SQL: select * fr  om information_schema.tables where table_schema = dev_oms and table_name = migra  tions)      at D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.  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:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnectors  Connector.php:68      2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=dev_oms", "root",  "root", [])    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnectors  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.      IlluminateDatabaseQueryException : 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:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.  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:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection  .php:458   2 PDOStatement::execute()    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection  .php:458   Please use the argument -v to see more details.

数据库编码改为utf8mb4

报错三

  $ php artisan migrate  Migration table created successfully.      IlluminateDatabaseQueryException : 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:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.  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:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection  .php:458   2 PDOStatement::execute()    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection  .php:458   Please use the argument -v to see more details.

加上两行代码即可

以上这篇laravel执行php artisan migrate报错的解决方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持<计算机技术网(www.ctvol.com)!!>。

—-想了解laravel执行php artisan migrate报错的解决方法分享！且更多的php教程关注<计算机技术网(www.ctvol.com)!!>