OK thanks. How would you set the host so that you can access it from a remote location?
I'm trying to access a Vagrant box db with Heidi. On Friday, May 16, 2014 10:31:34 AM UTC+12, Michael DeHaan wrote: > > Seems reasonable to me since that's not a valid hostname? > > > > On Thu, May 15, 2014 at 6:12 PM, Wynne Pirini <[email protected]<javascript:> > > wrote: > >> If I run this... >> >> - name: Create/assign database user to db and grant permissions >> mysql_user: name={{ item.env.db_user }} >> password={{ item.env.db_password }} >> priv={{ item.env.db_name | default(item.site_name) >> }}.*:ALL,GRANT >> state=present >> login_host={{ item.env.db_host | default('localhost') }} >> with_items: web_site >> >> >> If item:env.db_host == 'localhost' it works. >> >> If item:env.db_host == '%' it fails. >> >> >> >> >> On Friday, May 16, 2014 9:57:59 AM UTC+12, Michael DeHaan wrote: >>> >>> It's a database error, so nothing with "with_nested". >>> >>> Key part: >>> >>> "You have an error in your SQL syntax; check the manual that >>> corresponds to your MariaDB server version for the right syntax to use near >>> '.* TO 'john'@'localhost'' at line 1" >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ansible Project" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/ansible-project/a29a6b5a-18ba-4fe9-b5a3-d763cfa13489%40googlegroups.com<https://groups.google.com/d/msgid/ansible-project/a29a6b5a-18ba-4fe9-b5a3-d763cfa13489%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9d6d1b3b-31ba-4f45-bc00-afe52152830e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
