MariaDBの初期設定を自動化するスクリプトを作ってみた

#!/bin/bash

# 対話モードをスクリプト化するexpectをインストール（すでに導入済みの場合不要）
sudo yum install expect -y

# mariadbのインストールおよび起動
sudo yum install mariadb mariadb-server -y
sudo systemctl start mariadb
sudo systemctl enable mariadb

# パスワード指定
MysqlRootPasswd=Password@123

# mysql_secure_installationの対話モードをスクリプト化
expect -c '
    set timeout 1;
    spawn sudo mysql_secure_installation;
    expect "Enter current password for root (enter for none): ";
    send -- "\n";
    expect "Set root password?";
    send -- "'Y'\n";
    expect "New password:";
    send -- "'"${MysqlRootPasswd}"'\n";
    expect "Re-enter new password:";
    send -- "'"${MysqlRootPasswd}"'\n";
    expect "Remove anonymous users?";
    send "Y\n";
    expect "Disallow root login remotely?";
    send "Y\n";
    expect "Remove test database and access to it?";
    send "Y\n";
    expect "Reload privilege tables now?";
    send "Y\n";
    interact;'

#!/bin/bash
 
# 対話モードをスクリプト化するexpectをインストール（すでに導入済みの場合不要）
sudo yum install expect -y
 
# パスワード指定
MysqlRootPasswd=Password@123
 
# mysqlユーザ作成、テーブル作成スクリプト化
expect -c '
    set timeout 1;
    spawn mysql -u root -p;
    expect "Enter password:";
    send -- "'"${MysqlRootPasswd}"'\n";
    expect "MariaDB \[\(none\)\]>";
    send -- "CREATE USER '\''user01'\''@'\''localhost'\'' IDENTIFIED BY '\''my_password'\'';\n"
    expect "MariaDB \[\(none\)\]>";
    send -- "CREATE DATABASE `db01`;\n"
    expect "MariaDB \[\(none\)\]>";
    send -- "GRANT ALL PRIVILEGES ON `db01`.* TO \"user01\"@\"localhost\";\n"
    expect "MariaDB \[\(none\)\]>";
    send -- "FLUSH PRIVILEGES;\n"
    expect "MariaDB \[\(none\)\]>";
    send -- "exit;\n"
    interact;'