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

[file-name 000047_2025-03-11_15-31-51.txt]