Skip to content

Instantly share code, notes, and snippets.

@RomkeVdMeulen
Last active August 29, 2015 14:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RomkeVdMeulen/b84d07b8f3f7bfd73f03 to your computer and use it in GitHub Desktop.
Save RomkeVdMeulen/b84d07b8f3f7bfd73f03 to your computer and use it in GitHub Desktop.
Bash function for interacting with dockerized mysql server
# Use `mysqlroot` to go to interactive mysql shell,
# type e.g. `mysqlroot "SHOW DATABASES" to directly execute query
# or type `mysqlroot my-script.sql` to execute script
function mysqlroot() {
if [ $# -eq 0 ]; then
docker run -it --link mysql_mysql_1:mysql --rm mariadb sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'
else
if [ -f $1 ]; then
cat $1 | docker run -i --link mysql_mysql_1:mysql --rm mariadb sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'
else
echo $1 | docker run -i --link mysql_mysql_1:mysql --rm mariadb sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'
fi
fi
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment