# mysql\_db模块 [mysql\_db模块](http://docs.ansible.com/ansible/latest/mysql_db_module.html)用于建立、删除、导入和导出数据库 #### 建立数据库 `state="present"` ``` --- - name: mysql hosts: s.hi.com tasks: - name: create a database mysql_db: login_host: "127.0.0.1" login_user: "root" login_password: "mysql@123" login_port: "3306" name: "mezz" encoding: "utf8" state: "present" ``` #### 删除数据库 `state="absent"` ``` --- - name: mysql hosts: s.hi.com tasks: - name: delete a database mysql_db: login_host: "127.0.0.1" login_user: "root" login_password: "mysql@123" login_port: "3306" name: "mezz" state: "absent" ``` #### 导出数据库 `state="dump"` ``` --- - name: mysql hosts: s.hi.com tasks: - name: dump a database mysql_db: login_host: "127.0.0.1" login_user: "root" login_password: "mysql@123" login_port: "3306" name: "mezz" target: "/tmp/mezz.gz" state: "dump" ``` #### 导入数据库 `state="import"` ``` --- - name: mysql hosts: s.hi.com tasks: - name: import a database mysql_db: login_host: "127.0.0.1" login_user: "root" login_password: "mysql@123" login_port: "3306" name: "mezz" target: "/tmp/mezz.gz" state: "import" ```