在全新安装的Laravel中,使用Valet运行应用程序工作得很好。问题在于尝试使用MySQL设置数据库。我可以创建一个数据库,并告诉MySQL使用它,但无法对其进行任何操作:
mysql> create database foobar;
Query OK, 1 row affected (0.09 sec)
mysql> use foobar;
Database changed
mysql> show tables;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
如果我尝试运行 php artisan migrate
命令,会得到以下结果:
PDOException : SQLSTATE[HY000] [2006] MySQL server has gone away
at /Users/isaacfennell/Sites/anything/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
64| if (class_exists(PDOConnection::class) && ! $this->isPersistentConnection($options)) {
65| return new PDOConnection($dsn, $username, $password, $options);
66| }
67|
> 68| return new PDO($dsn, $username, $password, $options);
69| }
70|
71| /**
72| * Determine if the connection is persistent.
Exception trace:
1 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=anything", "root", "", [])
/Users/isaacfennell/Sites/anything/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
2 Illuminate\Database\Connectors\Connector::createPdoConnection("mysql:host=127.0.0.1;port=3306;dbname=anything", "root", "", [])
/Users/isaacfennell/Sites/anything/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:98
Please use the argument -v to see more details.
我刚接触 Laravel 和 MySQL,无法解决这个问题 - 这是怎么回事?谢谢