hashbangcode / vlad

Vlad - Vagrant LAMP Ansible Drupal
173 stars 53 forks source link

Tweaked mysql rulebook so that connection via 127.0.0.1 is possible #221

Closed mccullya closed 9 years ago

mccullya commented 9 years ago

In order to connect to the DB (after SSH'ing in), this host needs to be set to 127.0.0.1, not the box IP. This was tested against connecting to the DB on PHP Storm

dixhuit commented 9 years ago

This one keeps changing. Quick note to remind us that if this gets merged we'll need to amend the docs to suit: http://vlad-docs.readthedocs.org/en/latest/applications/mysql

mccullya commented 9 years ago

What about perhaps putting both rules ( { boxipaddress } & 127.0.0.1) in?

philipnorton42 commented 9 years ago

I would say that instead of replacing the root user task you could just create another task that does the 127.0.0.1 host. Or, create a with_items task that loops through both addresses.

mccullya commented 9 years ago

Yup, makes sense. I've updated this PR to have two tasks. Tested OK for me on a fresh vagrant instance..

philipnorton42 commented 9 years ago

Thanks for the update Andrew! Sorry it's been a while since my last update (I've been moving house) :)