Can't figure out how to connect to the database via CLI

fmitchell

Been stuck trying to figure out how to connect to my mysql database stack via drush. I did the export command you suggested, but when using /vendor/bin/drush sqlc, I get

[warning] The shell command 'mysql' is required but cannot be found. Please install it and retry.

I initially tried installing it globally with brew, but that didn't seem to work either. What is the best way to interact with the stack's mysql db from the command line using the PHP stack, i.e. drush?

Indigo

Hi @fmitchell — sorry that using Indigo services from the command line is currently a bit convoluted! It's high on my roadmap to implement something to make this much better. You've done the right thing using EXPORT commands, but I fear the export command you used may have just been for PHP? To use MySQL on the command line you'd need to do a similar version as the PHP's but for MySQL:

export PATH=~/.indigo/stacks/STACKID/mysql_ABCD/bin:$PATH

Let me know how you get on!

fmitchell

Success! Thank you.

Indigo

Just a heads-up that shell integration has been implemented in beta 15. Check out the docs for more info.