env: mysql: No such file or directory after `wp im

Question

I'm trying to import a database locally using wp db import databasename.sql but I get the following error: env: mysql: No such file or directory. Can anyone tell me how to resolve this?

Answer 1

I resolved this by changing my $PATH, run this in command or update your .bash_profile:

export PATH=$PATH:/usr/local/mysql/bin

Answer 2

The above didn't help me. I fixed it by adding this to my .bash_profile:

export PATH=$PATH:/Applications/MAMP/Library/bin/