mysql_user does not find /root/.my.cnf

[Ed Greenberg]

My ansible 2.9.10-1.el7 connects to the target machines as root. 

On my target machines, I have /root/.my.cnf with a root password defined under the section [mysql]. 

Here is the playbook and response

- hosts: databaseservers

  tasks:

  - name: add user to mysql

    mysql_user:

      name: "{{ name }}"

      host: "{{ item }}"

      password: "{{ password }}"

      encrypted: no

      priv: '*.*:ALL'

      login_unix_socket: /var/lib/mysql/mysql.sock

      state: present

    with_items:

      - localhost

      - 127.0.0.1

      - ::1

and I get...

failed: [awsbeta.happysoftware.com] (item=localhost) => {"ansible_loop_var": "item", "changed": false, "item": "localhost", "msg": "unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1045, u\"Access denied for user 'root'@'localhost' (using password: NO)\")"}

Note that using password is NO.

Most of the posts here concern setting the root password. One fellow, from 2016, questioned on what path the .my.cnf needed to be.  Since I log in as root, I figure it's /root/.my.cnf.  

My /root/.my.cnf is:

[mysql]

user=root

password=xxxxxxxxxxx

[mysqldump]

user=databasebackup

password=xxxxxxxxxxx

Do I need another section, perhaps?  What else might be wrong?

Thanks,

Ed Greenberg

[Raju Das]

http://fixyacloud.com/unable-to-create-mysql-database-through-ansible/   --- > check this link if it helps.

Check:- login_unix_socket: if it is define correct.

https://docs.ansible.com/ansible/latest/modules/mysql_user_module.html

With Regards

Raju Das

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/bd2ec9d1-3259-4220-b365-587e220c5a5an%40googlegroups.com.