ansible操作数据库初始化

数据库初始化脚本

初始化的时候只要执行一次就好，不用重复的调用

[root@m-61 ~]# cat db_init.yaml 
- hosts: 10.0.0.51
  tasks:
  - name: 01_yum_install
    yum: 
      name: "{{item}}"
      state: installed
    loop: 
      - mariadb-devel
      - mariadb-server
      - python-devel
      - python2-pip
      - MySQL-python
    notify:
      - db_updatauser
      - db_database
      - db_user

  - name: 02_statr_mariadb
    systemd:
      name: mariadb
      state: started
      enabled: yes

  handlers:
    - name: db_updatauser
      mysql_user:
        user: root
        password: 123
        update_password: always
      no_log: True
  
    - name: db_database
      mysql_db:
        login_host: "127.0.0.1"
        login_user: "root"
        login_password: "123"
        login_port: "3306"
        name: "wordpress"
        encoding: "utf8"
        state: "present"
      no_log: True
   
    - name: db_user
      mysql_user:
        login_host: "127.0.0.1"
        login_user: "root"
        login_password: "123"
        login_port: "3306"
        name: 'wordpress'
        password: 'wordpress'
        priv: 'wordpress.*:ALL'
        host: '172.16.1.%'
        state: present
      no_log: True