Enabling drush connections from host about ansible-role-mysql

[geerlingguy]

There are a few different options here...

One, which I prefer, as it leaves things simpler on the configuration side, is to update your drush aliases to connect via SSH properly:

$aliases['local'] = array(
  'root' => '/my-drupal-site', # the root inside your VM
  'remote-host' => 'drupaltest.dev', # the IP or domain of the drupal-dev-vm
  'remote-user' => 'vagrant', # leave this set to vagrant
  'uri' => 'local.mysite.com', # the domain of the site you're controlling with this alias
  'ssh-options' => '-i ~/.vagrant.d/insecure_private_key', # path to the private key for SSH
);

This works for me without issue, and allows all drush commands to work correctly from my control machine.

Another option would be to simply give the root user access to everything on every host, as you did with your earlier puppet-based environment. Just add the following into your config.yml, and the user will be created on provision:

mysql_users:
  - { name: root, host: "%", password: secret, priv: *.*:USAGE }