MySQL5.7での初期ユーザー設定

忘れるのでメモ
ルートパスワードを好きなものに変更するバッチ。
パスワードの強度は最低にする。root/rootでもOK。なので、使用は注意。

# !/bin/bash

MYROOTPASSWORD='password'

DEFAULT_PASSWORD=`cat /var/log/mysqld.log | grep "temporary password" | awk '{print $11}'`
mysql -u root -p${DEFAULT_PASSWORD} --connect-expired-password -e "SET GLOBAL validate_password_length=4;"
mysql -u root -p${DEFAULT_PASSWORD} --connect-expired-password -e "SET GLOBAL validate_password_policy=LOW;"
mysql -u root -p${DEFAULT_PASSWORD} --connect-expired-password -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '${MYROOTPASSWORD}';"

サブアカウントを作るバッチ。

# !/bin/bash
MYROOTPASSWORD='password'
MYSECONDUSER='root2'
MYSECONDPASSWORD='password2'

mysql -u root -p${MYROOTPASSWORD} -e "SET GLOBAL validate_password_length=4;"
mysql -u root -p${MYROOTPASSWORD} -e "SET GLOBAL validate_password_policy=LOW;"
mysql -u root -p${MYROOTPASSWORD} -e "create user ${MYSECONDUSER}@localhost identified by '${MYSECONDPASSWORD}';"
mysql -u root -p${MYROOTPASSWORD} -e "grant all on *.* to ${MYSECONDUSER}@localhost identified by '${MYSECONDPASSWORD}';"
mysql -u root -p${MYROOTPASSWORD} -e "grant all on *.* to ${MYSECONDUSER}@'%' identified by '${MYSECONDPASSWORD}';"
mysql -u root -p${MYROOTPASSWORD} -e "flush PRIVILEGES;"