How can I connect via Symfony 4 to mySQL database created with MAMP?

Question

I created a database in MAMP called "project".

In my .env file I added this line:

DATABASE_URL=mysql://root:root@localhost:3306/project

Now I want to run

php bin/console doctrine:database:create

But I get an error message:

SQLSTATE[HY000] [2002] No such file or directory

my doctrine configurations:

parameters:
    # Adds a fallback DATABASE_URL if the env var is not set.
    # This allows you to run cache:warmup even if your
    # environment variables are not available yet.
    # You should not need to change this value.
    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

Can you show please the doctrine configuration?

Alessandro Minoccheri
– Alessandro Minoccheri

2018-06-18 10:43:14 +00:00
Commented Jun 18, 2018 at 10:43 — Alessandro Minoccheri
– Alessandro Minoccheri, Commented Jun 18, 2018 at 10:43
@AlessandroMinoccheri Where do I find it?

peace_love
– peace_love

2018-06-18 10:44:27 +00:00
Commented Jun 18, 2018 at 10:44 — peace_love
– peace_love, Commented Jun 18, 2018 at 10:44
you mean config/packages/doctrine.yaml?

peace_love
– peace_love

2018-06-18 10:44:54 +00:00
Commented Jun 18, 2018 at 10:44 — peace_love
– peace_love, Commented Jun 18, 2018 at 10:44
yes exactly please add it

Alessandro Minoccheri
– Alessandro Minoccheri

2018-06-18 10:45:22 +00:00
Commented Jun 18, 2018 at 10:45 — Alessandro Minoccheri
– Alessandro Minoccheri, Commented Jun 18, 2018 at 10:45
@AlessandroMinoccheri Added it

peace_love
– peace_love

2018-06-18 10:46:28 +00:00
Commented Jun 18, 2018 at 10:46 — peace_love
– peace_love, Commented Jun 18, 2018 at 10:46

peace_love · Accepted Answer · 2018-06-18 11:51:45Z

9

Solved it!

in the file "config/packages/doctrine.yaml" I had to add this line

unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock

This means change this:

 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)%'

into

 dbal:
        # configure these for your database server
        driver: 'pdo_mysql'
        server_version: '5.7'
        charset: utf8mb4
        unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock
        default_table_options:
            charset: utf8mb4
            collate: utf8mb4_unicode_ci

        url: '%env(resolve:DATABASE_URL)%'

answered Jun 18, 2018 at 11:51

peace_love

6,52314 gold badges87 silver badges187 bronze badges

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

3 Comments

Rufinus Over a year ago

I can give you some background on your error: if you use localhost it has special meaning and mysql-client lib tries to connect via socket. as your socket is not in one of the default locations you have to give dbal the exact location. You also can change localhost to 127.0.0.1 to enforce a TCP connection, which would not use the socket.

peace_love Over a year ago

@Rufinus I tied to use 127.0.0.1 instead of localhost but then I got the error "Connection failed"

thi3rry Over a year ago

You can also put a unix_socket param in the DATABASE_URL of your environment file e.g. .env.local : DATABASE_URL=mysql://root:root@localhost:3306/dbname?unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock

Markus Antoni · Accepted Answer · 2019-10-10 21:17:18Z

6

Got the same problem. Added the unix_socket and changed 127.0.0.1 to localhost works on MAMP 5.5.

doctrine.yaml

doctrine:
dbal:
    # configure these for your database server
    driver: 'pdo_mysql'
    server_version: '5.7'
    charset: utf8mb4
    unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock
    default_table_options:
        charset: utf8mb4
        collate: utf8mb4_unicode_ci

    url: '%env(resolve:DATABASE_URL)%'

.env

DATABASE_URL=mysql://root:root@localhost:3306/mydb

answered Oct 10, 2019 at 21:17

Markus Antoni

611 silver badge1 bronze badge

1 Comment

devXen Over a year ago

this worked for me

Alessandro Minoccheri · Accepted Answer · 2018-06-18 10:48:22Z

1

Try to change this:

url: '%env(resolve:DATABASE_URL)%'

to this:

url: '%env(DATABASE_URL)%'

answered Jun 18, 2018 at 10:48

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Comments

Saravanan Nandhan · Accepted Answer · 2018-06-18 12:10:34Z

1

What you can also try is setting the mysql server expliclitly

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                dbname:         local_api
                user:           root
                password:       null
                host:           localhost
                driver:         pdo_mysql
                server_version: '5.5' # in case you are using mysql 5.5

answered Jun 18, 2018 at 12:10

Saravanan Nandhan

61211 silver badges19 bronze badges

1 Comment

Vlad Over a year ago

I have the same problem today. It's 5 years later after this question date. Terrible! Why do maintainers can't make this setting easier?

Collectives™ on Stack Overflow

How can I connect via Symfony 4 to mySQL database created with MAMP?

4 Answers 4

3 Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related