** (Mariaex.Error) tcp connect: econnrefused - How to connect ecto to MYSQL DB in Vagrant?

Phoenix Forum Questions / Help
,
1

Hello, please I’m having issue connecting ecto to a MYSQL db inside vagrant.

I’m on a mac and I have a vagrant setup (Linux, MYSQL, PHP).

I have elixir setup on the host machine.

I want my to connect my phoenixapp to the MYSQL db on the vagrant. Below is my configuration in dev.exs

config :product, Product.Repo,
  adapter: Ecto.Adapters.MySQL,
  username: "root",
  password: "testpassword",
  database: "testdb",
  hostname: "localhost",
  pool_size: 10

The bind-address: 127.0.0.1 on the MYSQL. I’ve changed the hostname: "localhost" to hostname: "127.0.0.1" without any success.

Please how can i fix this issue.

Thanks in advance.

2

I found the solution. This link Error connecting to remote database through SSH tunnel · Issue #313 · elixir-ecto/postgrex · GitHub gave me the hint.