mysql - Ansible 访问因“root@localhost”错误而被拒绝

问题描述

我正在尝试通过 Ansible playbook 创建一个 mysql 数据库。在阅读了这里的几个主题和问题之后，我创建了这样的剧本 -

---
- name: "Install Packages"
  hosts: localhost
  connection: local
  become: yes
  vars:
    mysql_root_password: Test@1123

  tasks:

  - name: Install basic packages
    apt:
      name:
      - vim
      - curl
      - python3-pip
      - mysql-server
      - libmysqlclient-dev
      - python-pymysql
      state: latest
      cache_valid_time: 3600

  - name: start & enable mysql Server
    service:
      name=mysql
      state=started
      enabled=yes

  - name: checking RabbitMQ & mysql Server status
    command: systemctl status "{{ item }}"
    with_items:
    - mysql
    register: result
    ignore_errors: yes

  - name: showing mysql Server status
    debug:
     var: result

  - name: Install pip modules
    pip:
      name:
      - pymysql
      - virtualenv
      state: present
      executable: /usr/bin/pip3

  - name: create /root/.my.cnf with password credentials
    blockinfile:
      path: /root/.my.cnf
      block: |
        [client]
        user=root
        password={{ mysql_root_password }}

        [mysql]
        user=root
        password={{ mysql_root_password }}

        [mysqldump]
        user=root
        password={{ mysql_root_password }}

        [mysqldiff]
        user=root
        password={{ mysql_root_password }}
      create: yes

  - name: "Mysql Configuration - Resetting RootPassword"
    mysql_user:
      login_user: root
      login_password: ''
      name: root
      host_all: yes
      password: "{{mysql_root_password}}"

  - name: Create a new database with name 'test'
    mysql_db:
      login_user: root
      login_password: "{{mysql_root_password}}"
      login_unix_socket: /run/mysqld/mysqld.sock
      name: test
      state: present

  - name: Create database user with name 'test' and password 'Test@1123' with all database privileges
    mysql_user:
      name: test
      password: Test@1123
      priv: '*.test:ALL'
      state: present

在运行这个剧本时，我遇到了错误 -

TASK [Mysql Configuration - Resetting RootPassword] *****************************************************************************************************************************************
[WARNING]: Module did not set no_log for update_password
fatal: [localhost]: FAILED! => {"changed": false, "msg": "unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1698, u\"Access denied for user 'root'@'localhost'\")"}

我已检查 /root/.my.cnf 文件已更新为正确的用户名和密码。

我试着跑mysql -u root -p。这已经成功了，没有任何密码。但是在尝试运行mysql -u 'root'@'localhost' -p时，无论有没有密码都不允许进入mysql。

我知道这可以手动修复几种方法。但是如何用 Ansible 解决这个问题。可能是我犯了一些愚蠢的错误。但想不通。我也尝试过没有 /root/.my.cnf 文件和没有套接字文件。但面临同样的问题。

更新：

我按照这个解决了这个问题

标签： mysqlansible

- name: "Mysql Configuration - Resetting RootPassword" mysql_user: login_user: root login_password: actual_root_mysql_password host: '' name: root password: "{{mysql_root_password}}"

mysql - Ansible 访问因“root@localhost”错误而被拒绝

问题描述

解决方案

推荐阅读