Attention: Turns out there are a few bugs which basically make mysql-utilities not usable atm.

On Ubuntu 16.04LTS install

sudo apt-get install mysql-utilities

To create a login-path run the followng, which will first prompt you to enter a password and then save the information.

mysql_config_editor set --login-path=prod --host=localhost --user=root --password

Once saved, you can use it like so:

mysql --login-path=prod

At the time of writing, the available options are:

host        no default value)
login-path  client
user        no default value
socket      no default value
port        no default value 

To print all the login-paths that are configured run:

mysql_config_editor print --all

If you need to remove an existing login-path use

mysql_config_editor remove --login-path=prod

If you are tired of having to repeat your git password over and over: https://git-scm.com/docs/git-credential-store

VIM configuration

Copy the vimrc_example.vim to your home dir cp /usr/share/vim/vim73/vimrc_example.vim ~/.vimrc Download http://www.vim.org/scripts/script.php?script_id=2465 Place in ~/.vim/colors (if folder does not exist, create it) Open the copied .vimrc and append the following two lines: set bg=dark colorscheme wombat256mod

MySQL: How to clone a database

Here's one way of duplicating a mysql database:
1. Make a dump of the source database: If you only want to dump the structure simply add --no-data to the end of the above command. 2. Open up a MySQL shell: 3. Within the MySQL shell, create a new database and populate it with the dumped data: 4. Optionally create a new user. Give permissions to the new database:

How to: Shared Folder Permissions Denied - Virtualbox

Make sure that the user is a member of the group vboxsf. sudo adduser xxxxxxx vboxsf

How-to: Guest Additions for VirtualBox 4.3 - Debian 7 (or any of it's derivatives)

Guest Additions is picky about dkms and wanting to build kernel modules. Open the Root Terminal: apt-get install build-essential module-assistant Once installed, the module-assistant can fetch the Linux headers: m-a prepare Have the Guest Additions CD image loaded in your virtual CD drive (VirtualBox "Devices" menu), but don't expect Autorun to work, it only returns "Error autorunning software. Cannot find the autorun program." Don't ask. Instead, still in the Root Terminal, run: sh /media/cdrom/VBoxLinuxAdditions.run and follow the installation prompts. You can then reboot with the 3D Acceleration, display resize and auto-resolution working again.

git with unverified ssl certificate

If you ever had to work with a remote repo which uses ssl (and it better!), but lacked a valid ssl certificate, you quickly realised that you can't actually work with it ;-) Solution: git config --global http.sslVerify false