mysqlconn - The mysql connection assistant

Instructions

Install:

gem install mysqlconn

Create ~/.db_connection_alias.yml

db_key:
  host: hostname
  user: username        # Optional
  password: password        # Optional
#  password: ''     # Optional, prompt for password
  database: database        # Optional
db_key2:
  ...

Protect configuration file:

chmod 600 ~/.db_connection_alias.yml

Usage

Connect:

mysqlconn db_key [additional options]

Pipe:

mysqlconn db_key < script.sql > output

etc..

Autocomplete

Add to bash.completion.d

_mysqlconn() {
  local cur=${COMP_WORDS[COMP_CWORD]}
  COMPREPLY=( $( compgen -W "$(mysqlconn -l)" -- $cur ) )
}
complete -F _mysqlconn mysqlconn

License

Apache 2.0 - go nuts