When using Ansible's mysql_query module ，result is that 'admin' is being censored

Question

When using Ansible's mysql_query module ，result is that 'admin' is being censored

Closed this issue 4 months ago · 2 comments

When using Ansible's mysql_query module to execute the SQL query:

SELECT TABLE_NAME FROM information_schema.TABLES where TABLE_NAME='op_admin_log'
And the result is that 'admin' is being censored, turning into 'op_******_log'。

Answer 1 · 2024-05-23T09:50:58.000Z

because mysql password is admin

Answer 2 · 2024-05-30T08:54:13.000Z

@yasyx hello, thanks for opening the issue! This ansible behavior isn't always good but it's how ansible-core handles these things for security reasons and we have no levers in this collection to make it not do this. Anyway, thanks!