How to rollback, reset, or drop Ecto test database?

You can access the test database by using MIX_ENV=test followed by a command such as mix do ecto.drop, mix ecto.reset or mix ecto.rollback.

In this particular case, I used:

MIX_ENV=test mix ecto.reset

If your application has multiple repos (DBs), you’ll want to specify a specific repo to avoid applying the operation to all repos. For example

mix ecto.drop --repo Order.Repo

To find out more about an Ecto task, use mix help <task>

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)