mikutas

<p><span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__e8ee1b35e2938" src="https://embed.zenn.studio/card#zenn-embedded__e8ee1b35e2938" data-content="https%3A%2F%2Fdocs.ansible.com%2Fansible%2Flatest%2Fcollections%2Fcommunity%2Fmysql%2Fmysql_user_module.html" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql_user_module.html" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://docs.ansible.com/ansible/latest/collections/community/mysql/mysql_user_module.html</a></p>


<p>変更前が失敗　変更後が成功<br>
SHOW DATABASESがグローバル権限でfoo.*を対象に定義できなくてだめ</p>
<div class="code-block-container"><pre class="diff-highlight "><code class="diff-highlight "><span class="token deleted-sign deleted"><span class="token prefix deleted">-</span>      priv: "foo.*:DELETE,INSERT,LOCK TABLES,SELECT,SHOW DATABASES,UPDATE"
</span><span class="token inserted-sign inserted"><span class="token prefix inserted">+</span>      priv: "foo.*:DELETE,INSERT,LOCK TABLES,SELECT,UPDATE/*.*:SHOW DATABASES"
</span></code></pre></div><hr>
<p>変更前が失敗　変更後が成功<br>
カンマ後のスペースがだめ（SQLでは問題ないがこのモジュールではだめ）</p>
<div class="code-block-container"><pre class="diff-highlight "><code class="diff-highlight "><span class="token deleted-sign deleted"><span class="token prefix deleted">-</span>      priv: "*.*:SELECT,REPLICATION SLAVE,REPLICATION CLIENT,GRANT, SHOW DATABASES/%.*:ALL"
</span><span class="token inserted-sign inserted"><span class="token prefix inserted">+</span>      priv: "*.*:SELECT,REPLICATION SLAVE,REPLICATION CLIENT,GRANT,SHOW DATABASES/%.*:ALL"
</span></code></pre></div>