planforfailure

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

Ansible variable precedence

Source: http://docs.ansible.com/ansible/latest/playbooks_variables.html#variable-precedence-where-should-i-put-a-variable

From least to most important

command line values (for example, -u my_user, these are not variables)
role defaults (defined in role/defaults/main.yml)
inventory file or script group vars
inventory group_vars/all

Useful LXD commands

Summarized from https://stgraber.org/2016/03/19/lxd-2-0-your-first-lxd-container-312/.

Interestingly, the LXD command line client is named.... lxc!

List available containers

lxc image list ubuntu:        # ubuntu: is officially supported image source
lxc image list images:        # images: is an unsupported source
lxc image alias list images:  # lists user-friendly names

	vSphere 6 Enterprise Plus:
	1C20K-4Z214-H84U1-T92EP-92838
	1A2JU-DEH12-48460-CT956-AC84D
	MC28R-4L006-484D1-VV8NK-C7R58
	5C6TK-4C39J-48E00-PH0XH-828Q4
	4A4X0-69HE3-M8548-6L1QK-1Y240

	vSphere with Operations Management 6 Enterprise:
	4Y2NU-4Z301-085C8-M18EP-2K8M8
	1Y48R-0EJEK-084R0-GK9XM-23R52