有没有办法使用ansible连接mysql服务器，并执行诸如执行.sql文件和各种mysql转储和恢复链接之类的操作？

[mysql_servers]
mysql_server ansible_host=192.168.1.100 ansible_user=username ansible_password=password

---
- name: Execute MySQL operations
  hosts: mysql_servers
  tasks:
    - name: Execute SQL file
      mysql_db:
        login_host: "{{ ansible_host }}"
        login_user: "{{ ansible_user }}"
        login_password: "{{ ansible_password }}"
        name: mydatabase
        state: import
        target: /path/to/sql/file.sql

    - name: Dump MySQL database
      mysql_db_dump:
        login_host: "{{ ansible_host }}"
        login_user: "{{ ansible_user }}"
        login_password: "{{ ansible_password }}"
        name: mydatabase
        state: dump
        target: /path/to/dump/file.sql

    - name: Restore MySQL database
      mysql_db_restore:
        login_host: "{{ ansible_host }}"
        login_user: "{{ ansible_user }}"
        login_password: "{{ ansible_password }}"
        name: mydatabase
        state: import
        target: /path/to/dump/file.sql

ansible-playbook -i inventory playbook.yml