Symfony 4 Doctrine 不能从控制台工作 [2002] 没有这样的文件或目录

2022-01-16 00:00:00 php symfony doctrine symfony4 symfony-flex

我正在使用 symfony 4,并且在运行学说控制台命令时出现此错误:

I´m working with symfony 4 and this error ocurr when runnning doctrine console commands:

In AbstractMySQLDriver.php line 108:

An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory  

我认为这是因为连接有问题,但是当我运行应用程序时,它可以毫无错误地访问数据库,所以我无法想象连接有什么问题.

I think this is because there´s something wrong with the connection but when I run the application it has access to the database without errors, so I can not imagine what is wrong with the connection.

我能够通过手动创建数据库并使用来继续工作

I was able to continue working by creating manually the database and using

php bin/console doctrine:schema:create --dump-sql

但这确实是不需要的,因为稍后当需要更新架构时,所有数据都会丢失,因为我需要重新创建架构而不是更新它.

But this is really unwanted because later when the schema needs to be updated all data would be lost because i would need to re-create the schema instead of updating it.

手动执行 SQL 后应用正常运行(easyadmin 运行正常).

The app works normally after executing manually the SQL (easyadmin works fine).

这是我的配置:

.ENV:

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

doctrine.yaml:

doctrine.yaml:

parameters:
     env(DATABASE_URL): ''

doctrine:
    dbal:
       driver: 'pdo_mysql'
       server_version: '5.7'
       charset: utf8mb4

我尝试了 drop 命令只是为了测试它抛出了这个:

I tried the drop command just to test and it throwed this:

In DropDatabaseDoctrineCommand.php line 93:


Connection does not contain a 'path' or 'dbname' parameter and cannot be dropped.  

所以我将 dbname 添加到教义.yaml 并没有工作.我也试过删除缓存,创建一个新项目,使用远程mysql,使用sqlite,但两种情况下的错误都是一样的!!

So I add dbname to doctrine.yaml and didn´t worked. I also tried removing the cache, creating a new project, using a remote mysql, and using sqlite but the errors are the same in both cases !!

提前感谢您的帮助!

推荐答案

请将DB_HOST=localhost改为DB_HOST=127.0.0.1

DATABASE_URL=mysql://${DB_USER}:${DB_PASSWORD}@${DB_HOST}:${DB_PORT}/${DB_NAME}

相关文章