TrashNotes

- name: Установка и настройка MariaDB
  hosts: centos_servers

  tasks:
    - name: Установка необходимых пакетов
      yum:
        name: "{{ item }}"
        state: latest
      with_items:
        - mariadb
        - mariadb-server
        - mariadb-devel

    - name: Запуск и включение MariaDB
      service:
        name: mariadb
        state: started
        enabled: yes

    - name: Настройка безопасности MariaDB
      shell: |
        mysql -u root <<-EOF
          UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
          DELETE FROM mysql.user WHERE User='';
          DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
          DROP DATABASE IF EXISTS test;
          DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
          FLUSH PRIVILEGES;
        EOF
      args:
        executable: /bin/bash
      become: yes


# command-r-plus