# Ansible playbook code for connecting remote MYSQL db

**URL:** <https://forum.ansible.com/t/ansible-playbook-code-for-connecting-remote-mysql-db/37458>\
**Category:** Ansible Project\
**Tags:** ansible-project\
**Created:** [December 12, 2022, 5:36pm UTC](https://forum.ansible.com/t/ansible-playbook-code-for-connecting-remote-mysql-db/37458 "2022-12-12T17:36:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![saravanan\_jothilinga](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@saravanan\_jothilinga](https://forum.ansible.com/u/saravanan_jothilinga)\
**Post date:** [December 12, 2022, 5:36pm UTC](https://forum.ansible.com/t/ansible-playbook-code-for-connecting-remote-mysql-db/37458/1 "2022-12-12T17:36:51Z")

</div>

Hi  
I am a novice to ansible and slowly making my hand dirty out of it. I am trying out a usecase where I need to connect to a remote mysql dbserver from my ansible controller machine and execute some queries against that DB. I would like to know if there is any customized ansible playbook available to try with?

Appreciate this help!

Thanks  
Saravanan

---

<div class="post-metadata">

**Author:** ![dnmvisser](https://avatars.discourse-cdn.com/v4/letter/d/8e8cbc/32.png) [@dnmvisser](https://forum.ansible.com/u/dnmvisser)\
**Post date:** [December 12, 2022, 5:54pm UTC](https://forum.ansible.com/t/ansible-playbook-code-for-connecting-remote-mysql-db/37458/2 "2022-12-12T17:54:50Z")

</div>

Use this task locally:  
[https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql\_query\_module.html](https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql_query_module.html)