symfony - 使用学说或 symfony 创建数据库时出错

Question

当我尝试使用命令创建数据库时

$ php bin/console doctrine:database:create

我得到那些错误

2019-04-02T12:45:01+02:00 [error] Error thrown while running command "doctrine:d
atabase:create". Message: "An exception occurred in driver: SQLSTATE[HY000] [104
5] Access denied for user 'root'@'localhost' (using password: YES)"

In AbstractMySQLDriver.php line 93:

  An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for u
  ser 'root'@'localhost' (using password: YES)


In PDOConnection.php line 31:

  SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas
  sword: YES)


In PDOConnection.php line 27:

  SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas
  sword: YES)

我卸载了 xmapp、composer、symbony 并重新安装了它们。

• PHP 版本 7.3.3
• Composer 版本 1.8.4
• Symfony CLI 版本 v4.3.3

按照这些步骤安装在此处找到的 orm 学说 https://symfony.com/doc/current/doctrine.html

 composer require symfony/orm-pack
 composer require --dev symfony/maker-bundle

修改后的 .env 文件

DATABASE_URL=mysql://root:123456@127.0.0.1:3306/test

然后，执行

php bin/console doctrine:database:create

然后，错误就来了。

Answer 1

.env 文件看起来像这样:

DATABASE_URL=mysql://root:123456@127.0.0.1:3306/articles

我刚刚删除了密码，问题就解决了:

DATABASE_URL=mysql://root@127.0.0.1:3306/articles

现在数据库已创建。