Ansible error ERROR!couldn't resolve module/action 'community.mysql.mysql_db'. This often indicates a misspelling, missing collection, or incorrect module path.

couldn't resolve module/action 'community.mysql.mysql_db'. This often indicates a misspelling, missing collection, or incorrect module path.

Solution:

Execute the below in ansible in controller
ansible-galaxy collection install community.mysql