ansible 编写 mysql_use 模块的使用
今天使用 ansible 安装管理 mariadb 数据库的时候, 碰到问题, 在网上找不到对应的解决办法. 然后自己查资料, 终于写出,
查阅资料: 编写如下脚本
- [root@manager-161 playbook]# cat MySQL.YAML
- - hosts: MySQL
- tasks:
- - name: install mariadb
- yum: name=mariadb-devel,mariadb-server state=installed
- - name: install python-devel pip
- yum: name=python-devel,python2-pip state=installed
- - name: shell mtsql-python
- shell: 'pip install MySQL-python'
- - name: statr mariadb
- service: name=mariadb state=started enabled=yes
- - mysql_user:
- user: root
- password: sf123
- update_password: always
- - name: create WordPress
- mysql_db:
- name: 'root'
- login_host: 'localhost'
- login_password: 'zsf123'
- name: 'WordPress'
- state: 'present'
- - mysql_user:
- user: 'root'
- login_host: 'localhost'
- login_password: 'zsf123'
- user: 'zzsf'
- password: 'zsf124'
- priv: '*.*:ALL'
- state: present
- - mysql_user:
- user: 'root'
- login_host: 'localhost'
- login_password: 'zsf123'
- user: 'zzsf'
- password: 'zsf124'
- priv: '*.*:ALL'
- host_all: yes
- state: present
- - mysql_db:
- user: 'root'
- login_host: 127.0.0.1
- login_password: zsf123
- name: lt
- state: present
- #mariadb 安装之后没有密码, 我们必须先更改 root 的密码
然后 MySQL 需要安装 MySQL-python 的模块
- yum -y install python-devel,python2-pip
- pip install MySQL
来源: https://www.qcloud.com/developer/article/1346310