Phinx: Problem connecting to mysql

[BardiaAfshin]

I have a situation where mysql is installed and when attempting to run a migration I get InvalidArgumentException:

  [InvalidArgumentException]
  There was a problem connecting to the database: SQLSTATE[HY000] [2002] No such file or directory

But I can connect to mysql find with the credentials, from command line

[shadowhand]

Can you please run phinx with -vvv (very verbose output) and paste the relevant error location in code?

Also, please paste your connection config (remove password though ;) ).

[shadowhand]

This error should only happen when you attempt to use the unix_socket config with an invalid path.

[BardiaAfshin]

sample yaml

    development:
        adapter: mysql
        host: localhost
        name: development_db
        user: root
        pass: ''
        port: 3306
        charset: utf8

I will have the output you requested later.

[shadowhand]

@BardiaAfshin any follow up on this?

[BardiaAfshin]

Not yet

[shadowhand]

Please reopen if you can provide more complete logging.

[karolsenami]

Hey there, I'm struggling with the same issue for all day long and I can't find a solution.
I'm on Mac OS

Edit : Found my solution : the problem was that I forgot to start MySQL server ! (I'm totally new to back-end and I feel stupid I didn't think about it)

[qsricardosevero]

Hi, I had the same issue when using phinx with mysql in a separate docker container. The cause was configuring the host as localhost in the phinx env file. After changing the host to 127.0.0.1 it worked!

[jesusalive]

Be

Hi, I had the same issue when using phinx with mysql in a separate docker container. The cause was configuring the host as localhost in the phinx env file. After changing the host to 127.0.0.1 it worked!

SO GOOOOOOOOOD. Worked for me