Setting mysql using ansible in ubuntu remote machine

Nikhil Chopra

5/8/24, 9:26 PM

I have written one ansible playbook for installing MySQL server in ubuntu remote machine but is not working here is the yaml code

---
- name: setting mysql in ubuntu
  hosts: web01
  become: yes
  tasks:
   - name: install mysql
     apt:
      name: mysql-server
      state: present
   - name: install python
     apt:
      name: python3-pymysql
      state: present
   - name: start & enable server
     service:
      name: mysql
      state: started
      enabled: yes
   - name: user setup in mysql
     mysql_user:
      check_implicit_admin: true
      login_user: root
      login_password: password
      user: root
      password: password
      host: web01
      priv: '*.*.:ALL,GRANT'
   - name: create db
     mysql_db:
      name: db
      state: present

everytime in user setup it is showing:

fatal: [web01]: FAILED! => {"changed": false, "msg": "unable to connect to database, check login_user and login_******** are correct or /root/.my.cnf has the credentials. Exception message: (1698, "Access denied for user 'root'@'localhost'")"}

the web01 is the ec2 server name in aws I have also configured the inventory file properly and check it using ad-hoc command -m ping

and I have also made .my.cnf in the path /root/.my.cnf in the target machine and I have entered it like:

[client]
user=root
password=password

323

1 + 0

mysql

ubuntu

ansible

ansible-playbook

Score:1

Server

Gerald Schneider

5/9/24, 6:24 AM

In the user setup task you are trying to connect to MySQL with the user credentials you want to set up, which doesn't exist at this point.

On Ubuntu MySQL is configured by default to accept connections from root via unix socket without a password.

If you change your task to this you can set up the root user:

    - name: user setup in mysql
      mysql_user:
       user: root
       password: password
       host: web01
       priv: '*.*:ALL,GRANT'
       login_unix_socket: /var/run/mysqld/mysqld.sock

^{(note that you also have a typo in your priv parameter I corrected)}

But technically you don't need to set up this root user at all, since you only need to provide the login_unix_socket parameter. You can set this up via module_defaults, so you don't need to specify it on every task:

- name: setting mysql in ubuntu
  hosts: web01
  become: yes
  module_defaults:
    mysql:
      login_unix_socket: /var/run/mysqld/mysqld.sock
  tasks:

You can just create your application database and the application user for it.

+ 1

Nikhil Chopra

5/9/24, 8:31 AM

It worked and I also wrote login_unix_socket: /var/run/mysqld/mysqld.sock in db also then that also worked thanks a lot

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Setting mysql using ansible in ubuntu remote machine

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.