mysql_user 与 priv 的问题

Question

在我的剧本中，我有类似的内容:

- name: Creates a mysql user
  mysql_user:
    login_host: "{{ db_host }}"
    login_user: "{{ db_user }}"
    login_password: "{{ db_password }}"
    name: my_user
    password: 123123
    state: present
    priv: "*.*:ALL"

如果我运行它，我会得到:

FAILED! => {"changed": false, "failed": true, "msg": "(1045, \"Access denied for user 'dbuser'@'%' (using password: YES)\")"}

但是，如果我在没有 priv 部分的情况下运行它:

- name: Creates a mysql user
  mysql_user:
    login_host: "{{ db_host }}"
    login_user: "{{ db_user }}"
    login_password: "{{ db_password }}"
    name: my_user
    password: 123123
    state: present

用户已正常创建。 priv 字符串是取自文档 here 的示例。 ，所以它应该有效。我测试了几个ansible版本(>1.9.4)

Answer 1

评论中的回答:

Does dbuser have enough permissions to grant my_user privileges to all databases?