# MYSQL Connectivity Issue in Ansible **URL:** \ **Category:** Ansible Project\ **Created:** [January 4, 2017, 4:48am UTC](https://forum.ansible.com/t/mysql-connectivity-issue-in-ansible/23372 "2017-01-04T04:48:57Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Mona\_Gopal](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@Mona\_Gopal](https://forum.ansible.com/u/Mona_Gopal)\ **Post date:** [January 4, 2017, 4:48am UTC](https://forum.ansible.com/t/mysql-connectivity-issue-in-ansible/23372/1 "2017-01-04T04:48:57Z")
Hello, I have the below task mysql\_user: login\_user={{ db\_user\_root }} login\_password={{ db\_pass\_root }} name={{ db\_user }} password={{ db\_pass }} priv=_._:ALL,GRANT state=present We’re facing issue on running this, from machine B to install on machine A. Installing from machine A to machine B is running fine. However, by specifying login\_host parameter this works fine. But, the same parameter is not essential while running from A to B. What could be the scenario?? why is that login\_host parameter is required when running from B to A and not vice versa. Thanks in advance, Mona G ---
**Author:** ![toshywoshy](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/toshywoshy/32/7855_2.png) [@toshywoshy](https://forum.ansible.com/u/toshywoshy)\ **Post date:** [January 4, 2017, 9:40am UTC](https://forum.ansible.com/t/mysql-connectivity-issue-in-ansible/23372/2 "2017-01-04T09:40:08Z")
> Hello, > > I have the below task > > mysql\_user: login\_user={{ db\_user\_root }} login\_password={{ db\_pass\_root > }} name={{ db\_user }} password={{ db\_pass }} priv=\*.\*:ALL,GRANT > state=present > > We're facing issue on running this, from machine B to install on machine > A. Installing from machine A to machine B is running fine. > > However, by specifying login\_host parameter this works fine. > > But, the same parameter is not essential while running from A to B. > > What could be the scenario?? why is that login\_host parameter is > required when running from B to A and not vice versa. I would be guessing, because you do not give enough information. I presume that your server my.cnf bind only to an IP on machine A, while machine B has a UNIX socket connection, the default MySQL python module uses a UNIX socket connection, while you can override that by using the 'login\_host' variable and then the module will use a TCP socket Another possibility is that your user running the Ansible task has a .my.cnf in $HOME which overrides the default host value, so you need to specify the correct one manually However this is a wild guess, for a better answer, more information is required. > Thanks in advance, > > Mona G Regards, Tosh. ---
**Author:** ![Mona\_Gopal](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@Mona\_Gopal](https://forum.ansible.com/u/Mona_Gopal)\ **Post date:** [January 4, 2017, 9:55am UTC](https://forum.ansible.com/t/mysql-connectivity-issue-in-ansible/23372/3 "2017-01-04T09:55:57Z")
Dear Tosh, Thanks a lot for your response πŸ™‚ We are checking on the parameters that you mentioned. Can you list out what more information is required for a better analysis of the same. Regards, Mona G ---
**Author:** ![toshywoshy](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/toshywoshy/32/7855_2.png) [@toshywoshy](https://forum.ansible.com/u/toshywoshy)\ **Post date:** [January 4, 2017, 11:42am UTC](https://forum.ansible.com/t/mysql-connectivity-issue-in-ansible/23372/4 "2017-01-04T11:42:10Z")
>     \> Hello, >     \> >     \> I have the below task >     \> >     \> mysql\_user: login\_user={{ db\_user\_root }} login\_password={{ >     db\_pass\_root >     \> }} name={{ db\_user }} password={{ db\_pass }} priv=\*.\*:ALL,GRANT >     \> state=present >     \> >     \> We're facing issue on running this, from machine B to install on >     machine >     \> A. Installing from machine A to machine B is running fine. >     \> >     \> However, by specifying login\_host parameter this works fine. >     \> >     \> But, the same parameter is not essential while running from A to B. >     \> >     \> What could be the scenario?? why is that login\_host parameter is >     \> required when running from B to A and not vice versa. > >     I would be guessing, because you do not give enough information. >     I presume that your server my.cnf bind only to an IP on machine A, >     while >     machine B has a UNIX socket connection, the default MySQL python module >     uses a UNIX socket connection, while you can override that by using the >     'login\_host' variable and then the module will use a TCP socket >     Another possibility is that your user running the Ansible task has a >     .my.cnf in $HOME which overrides the default host value, so you need to >     specify the correct one manually > >     However this is a wild guess, for a better answer, more information is >     required. > >     \> >     \> Thanks in advance, >     \> >     \> Mona G >     Regards, >     Tosh. Mona, > Dear Tosh, > > Thanks a lot for your response πŸ™‚ > We are checking on the parameters that you mentioned. > Can you list out what more information is required for a better > analysis of the same. Well, Ansible log, MySQL logs and configs I do not think it is actually Ansible. Remember to sanitized all credentials. > Regards, > Mona G Regards, Tosh.