Error when trying to create doctrine database with phpMyAdmin

Question

I'm a fresh junior php developer and I'm building my first Symfony project.

When I used the command : php bin/console doctrine:database:create I get these errors :

In AbstractMySQLDriver.php line 93:
An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory

In PDOConnection.php line 31:
SQLSTATE[HY000] [2002] No such file or directory

In PDOConnection.php line 27:
SQLSTATE[HY000] [2002] No such file or directory*

I'm actually using MAMP with default config "db_user" and "db_password" so I edited the .env file with this following code : DATABASE_URL=mysql://root:root@localhost:8889/mydbname

I know there is something wrong with my host or port, I saw on other topics that some users using MAMP keep Symfony default values for host and port : DATABASE_URL=mysql://root:[email protected]:3306/mydbname

Thanks for reading me and trying to help me.

kihA · Accepted Answer · 2020-01-02 14:16:24Z

1

I did more searches and some people are saying that localhost syntax is depreciated and prefer using : 127.0.0.1 instead of localhost.

In my case I checked and used Mamp config 'Connect using an UNIX socket'

So it's now working with :

`DATABASE_URL=mysql://root:[email protected]:8889/mydbname`

edited Jan 2, 2020 at 14:16

answered Dec 31, 2019 at 14:48

kihA

134 bronze badges

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

Collectives™ on Stack Overflow

Error when trying to create doctrine database with phpMyAdmin

1 Answer 1

`DATABASE_URL=mysql://root:[email protected]:8889/mydbname`

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

DATABASE_URL=mysql://root:[email protected]:8889/mydbname

Comments

Your Answer

Sign up or log in

Post as a guest

Related

`DATABASE_URL=mysql://root:[email protected]:8889/mydbname`