Ansible mysql grant

Question

I want to grant privilege on a db(test_db) to a user(test_user) using Ansible. My command is as shown below.

grant all PRIVILEGES on <test_db>.* to <test_user>@'localhost';

How will I execute the command using Ansible.

What have you tried so far with [mysql_user](http://docs.ansible.com/ansible/mysql_user_module.html)? — Konstantin Suvorov, Nov 08 '16 at 14:18

score 9 · Answer 1 · answered Nov 08 '16 at 15:49

9

You could do it like this:

- name: Set mysql user privileges
  mysql_user:
    name=user_name
    priv="dbname.*:ALL"
    state=present

Of course you can interpolate variables, like the username, db name, etc...

answered Nov 08 '16 at 15:49

Palantir

23,820
10
76
86

score 2 · Answer 2 · answered Jul 23 '19 at 15:24

2

- name: "Create user {{ user }}"
  mysql_user:
    name: "{{ user }}"
    password: "{{ password }}"
    host: localhost
    state: present
    update_password: on_create
    priv: "{{ dbname }}.*:ALL"
    login_unix_socket: /var/run/mysqld/mysqld.sock

Solutions works

answered Jul 23 '19 at 15:24

Thomas Boulanger

21
2

1

Thank you for this code snippet, which might provide some limited short-term help. A proper explanation [would greatly improve](//meta.stackexchange.com/q/114762) its long-term value by showing *why* this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please [edit] your answer to add some explanation, including the assumptions you've made. – Toby Speight Jul 23 '19 at 15:49

Ansible mysql grant

2 Answers2