Access denied when creating database with doctrine, Symfony 4

Question

I created a new Symfony 4 project and want to create a new database. I'm following this tutorial but can't get it to work. When running

php bin/console doctrine:database:create

I always get the same error:

In AbstractMySQLDriver.php line 112:
    An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'user_1'@'localhost' (using password: YES)

In PDOConnection.php line 50:
    SQLSTATE[HY000] [1045] Access denied for user 'user_1'@'localhost' (using password: YES)

In PDOConnection.php line 46:
    SQLSTATE[HY000] [1045] Access denied for user 'user_1'@'localhost' (using password: YES)

Following the tutorial, I configured database url in .env file, but it doesn't seem to change anything.

DATABASE_URL=mysql://user_1:[email protected]:3306/db_name

My config/packages/doctrine.yaml configuration:

parameters:
    env(DATABASE_URL): ''

doctrine:
    dbal:
        # configure these for your database server
        driver: 'pdo_mysql'
        server_version: '5.7'
        charset: utf8mb4
        default_table_options:
            charset: utf8mb4
            collate: utf8mb4_unicode_ci

        url: '%env(resolve:DATABASE_URL)%'
    orm:
        auto_generate_proxy_classes: '%kernel.debug%'
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        mappings:
            App:
                is_bundle: false
                type: annotation
                dir: '%kernel.project_dir%/src/Entity'
                prefix: 'App\Entity'
                alias: App

Tried everything and nothing seems to work. Any help would be greatly appreciated.

You could possibly troubleshoot with stackoverflow.com/q/10299148/2123530 — β.εηοιτ.βε
– β.εηοιτ.βε, Commented Jun 6, 2018 at 15:06

Valkeru · Accepted Answer · 2018-06-06 15:26:08Z

4

Possibly, your user has no permissions to CREATE DATABASE operation. Grant privileges to your user with grant CREATE on *.* to 'user_1'@'localhost'; in MySQL console.

edited Jun 6, 2018 at 15:26

answered Jun 6, 2018 at 15:13

Valkeru

614 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Khadija · Accepted Answer · 2018-06-06 14:43:36Z

1

refer to this similar issue

Possible reasons of the issue :

collation of your database
mysql credentials are invalid

answered Jun 6, 2018 at 14:43

Khadija

3081 silver badge10 bronze badges

1 Comment

mindaugasw Over a year ago

Thank you, this got me on the right path! I had development environment setup on this system a while ago. Turns out, reinstalling everything multiple times did not reset my database credentials. Finding old ones took some effort, but it works!

Alex Komp · Accepted Answer · 2018-06-06 14:43:40Z

0

Check connection with current credentials. Example for *nix

mysql -uuser_1 -p

When check mysql server's port

mysql> SHOW GLOBAL VARIABLES LIKE 'PORT';

answered Jun 6, 2018 at 14:43

Alex Komp

212 bronze badges

Comments

Ricardo Martins · Accepted Answer · 2023-02-09 03:16:46Z

0

Try to replace localhost for 127.0.0.1 in your .env(or other .env.*) file.

answered Feb 9, 2023 at 3:16

Ricardo Martins

6,0733 gold badges48 silver badges65 bronze badges

Collectives™ on Stack Overflow

Access denied when creating database with doctrine, Symfony 4

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related