问题描述
我正在使用 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}
这篇关于Symfony 4 Doctrine 不能从控制台工作 [2002] 没有这样的文件或目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！