使用Ansible community.mysql模块创建数据库时提示缺少MySQL Python模块的问题求助

我现在正尝试用Ansible的community.mysql模块搭建外部数据库，但执行创建数据库的任务时，一直弹出下面这个错误，实在摸不着头脑，来请教各位大佬：

failed: [target] (item=db_name) => {"ansible_loop_var": "item", "changed": false, "item": "db_name", "msg": "A MySQL module is required: for Python 2.7 either PyMySQL, or MySQL-python, or for Python 3.X mysqlclient or PyMySQL. Consider setting ansible_python_interpreter to use the intended Python version."}

我明明已经在控制节点上安装了mysqlclient和PyMySQL模块啊，先给大家贴一下我的环境信息：

控制节点上的Ansible版本：

vagrant@ctrl-01:~$ ansible --version

ansible [core 2.16.1]
config file = None
configured module search path = ['/home/vagrant/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
ansible python module location = /usr/local/lib/python3.10/dist-packages/ansible
ansible collection location = /home/vagrant/.ansible/collections:/usr/share/ansible/collections
executable location = /usr/local/bin/ansible
python version = 3.10.12 (main, Nov 20 2023, 15:14:05) [GCC 11.4.0] (/usr/bin/python3)
jinja version = 3.1.2
libyaml = True

控制节点上已安装的MySQL相关Python包：

vagrant@ctrl-01:~$ pip list |grep -i sql
mysqlclient            2.1.1
PyMySQL                1.1.0

已安装的community.mysql集合版本：

vagrant@ctrl-01:~$ ansible-galaxy collection list | grep mysql
community.mysql               3.8.0

我查了community.mysql模块的文档，没看到有额外的依赖要求，现在完全卡在这里了。

补充编辑：
看到有回复提到可能是目标节点的问题，我特意检查了目标节点，确认mysql、mysqldump二进制文件和PyMySQL模块都存在：

[root@galera01-rhel8 ~]# which mysql
/usr/bin/mysql
[root@galera01-rhel8 ~]# which mysqldump
/usr/bin/mysqldump
[root@galera01-rhel8 ~]# pip3 list | grep -i sql
PyMySQL      0.10.1

备注：内容来源于stack exchange，提问作者Patrick Reinboth