{"id":1209,"date":"2019-10-09T12:45:41","date_gmt":"2019-10-09T12:45:41","guid":{"rendered":"\/blog\/?p=1209"},"modified":"2019-10-09T12:46:25","modified_gmt":"2019-10-09T12:46:25","slug":"mysql-ansible-connection-example","status":"publish","type":"post","link":"\/blog\/index.php\/mysql-ansible-connection-example\/","title":{"rendered":"Mysql-Ansible connection example"},"content":{"rendered":"

– name: Retrieve stuff from mysql
\n command: >
\n mysql –user=alice –password=topsecret dbname
\n –host=147.102.160.1 –batch –skip-column-names
\n –execute=”SELECT stuff from stuff_table”
\n register: stuff
\n check_mode: no
\n changed_when: False<\/p>\n

– name: Do something with stuff
\n debug: “{{ item }}”
\n with_items: stuff.stdout_lines<\/p>\n

#—— another example
\n– name: Get username
\n command: mysql -u {{ username }} -p {{ mysql_root_password }} {{ database }} -Ns -e “”
\n register: username<\/p>\n

– debug: msg=”{{ username.stdout_lines }}”<\/p>\n","protected":false},"excerpt":{"rendered":"

– name: Retrieve stuff from mysql command: > mysql –user=alice –password=topsecret dbname –host=147.102.160.1 –batch –skip-column-names –execute=”SELECT stuff from stuff_table” register: stuff check_mode: no changed_when: False – name: Do something with stuff debug: “{{ item }}” with_items: stuff.stdout_lines #—— another example – name: Get username command: mysql -u {{ username }} -p {{ mysql_root_password }} {{ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1209","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1209"}],"version-history":[{"count":2,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1209\/revisions"}],"predecessor-version":[{"id":1211,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1209\/revisions\/1211"}],"wp:attachment":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1209"},{"taxonomy":"post_tag","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}