Home / Questions / 112457
Accepted
Oskar Calvo
Asked: 2020-10-27 03:18:40 +0800 CST 2020-10-27 03:18:40 +0800 CST

Doctrine error: Access denied for user in Symfony-4

  • 772

I am following the tutorial https://symfony.es/noticias/2017/05/02/symfony-4-un-example-practico/ , to start with Flex and they are Symfony.

The thing is that when executing: ./bin/console doctrine:database:create it returns me: ``` [Doctrine\DBAL\Exception\ConnectionException]
An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

[PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)
```

The thing is that I don't know where I have to indicate the connection values ​​to the database.

Can someone explain to me where the connection values ​​of the database are configured?

Thanks.

doctrine2

1 Answers

  1. Best Answer

    In Symfony4 and in the development environment it is recommended to indicate the connection in the .env file:

    ###> doctrine/doctrine-bundle ###
# Format described at http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
# For an SQLite database, use: "sqlite:///%kernel.project_dir%/var/data.db"
# Configure your db driver and server_version in config/packages/doctrine.yaml
DATABASE_URL=mysql://db_user:[email protected]:3306/db_name

    https://symfony.com/doc/current/doctrine.html#content_wrapper

    • 1