Setting up local MySQL applications
The MySQL database has a number of important settings that can be tweaked to change the setup. The most important of these is the
dbname setting. By default, this is set to the following:
This will generate a single database called 'vladdb' on the provisioned box. This can be increased to any number of databases by adding more items to the configuration list.
dbname: ['vladdb', 'database2']
It should be noted that the first database in this list is always used as the default 'main' database. This database is used by Vlad when running certain automatic actions such as checking if databases have been populated with tables.
Automatic database dumps
When you halt or destroy a VM, Vlad will attempt to automatically export all databases to files within the vlad_aux/db_io/halt_destroy directory.
Database dumps can be automatically imported when the box is provisioned by using the db_import_up variable. By default this action is disabled. This functionality can be re-run in isolation (on a previously provisioned VM) using the
mysql_import Ansible tag.
Connecting MySQL GUI apps
Sequel Pro (OS X)
Choose connection type "SSH" and complete the connection details as follows:
Name: Whatever you'd like to label this connection.
MySQL Host: value of
Username: value of
Password: value of
Database: a single value of
Port: value of
SSH Host: value of
SSH User: "vagrant"
SSH Key: "~/.vagrant.d/insecure_private_key" (browse to this file by clicking the key icon)
As above - the values go in the following dialog:
For remote access over SSH, you need to adjust the permissions for users from 127.0.0.1 (instead of just from 'localhost') on the MySQL database. i.e: grant all privileges on foo.* to firstname.lastname@example.org identified by 'rootpassword';