1.インストール

MySQLのインストール/初期設定

MySQLのインストール

dnf -y module install mysql

MySQLの有効化/起動

systemctl enable mysqld

systemctl start mysqld

MySQLの初期設定

下記コマンドを実行する。

mysql_secure_installation

対話セットアップが始まるので、要件に従って設定する。

#VALIDATE PASSWORD COMPONENT can be used to test passwords
#and improve security. It checks the strength of password
#and allows the users to set only those passwords which are
#secure enough. Would you like to setup VALIDATE PASSWORD component?

# 標準にあるパスワードポリシーを利用しますか?(8文字以下の英小文字のみなど利用したい場合は「No」)
Press y|Y for Yes, any other key for No:

#LOW    Length >= 8
#MEDIUM Length >= 8, numeric, mixed case, and special characters
#STRONG Length >= 8, numeric, mixed case, special characters and dictionary file

# 0 = LOW    : 8文字以上
# 1 = MEDIUM : 8文字以上、英数大文字、小文字、記号を全て含む。
# 2 = STRONG : 8文字以上、英数大文字、小文字、記号、辞書ファイルの指定文字列を全て含む。

#上記のポリシー(0 = LOW, 1 = MEDIUM and 2 = STRONG)から選択してください。
Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:

#rootパスワードを入力してください。
Please set the password for root here.

New password:

Re-enter new password:

#パスワードの推定強度:XXX
Estimated strength of the password: XXX

#このパスワードで続行しますか?
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) :

#By default, a MySQL installation has an anonymous user,
#allowing anyone to log into MySQL without having to have
#a user account created for them. This is intended only for
#testing, and to make the installation go a bit smoother.
#You should remove them before moving into a production
#environment.

#標準で匿名ユーザーが存在しますが削除しますか?
Remove anonymous users? (Press y|Y for Yes, any other key for No) :

#Normally, root should only be allowed to connect from
#'localhost'. This ensures that someone cannot guess at
#the root password from the network.

#rootユーザーをリモートログイン禁止にしますか?
Disallow root login remotely? (Press y|Y for Yes, any other key for No) :

#By default, MySQL comes with a database named 'test' that
#anyone can access. This is also intended only for testing,
#and should be removed before moving into a production
#environment.

#標準でtestデータベースが存在しますが削除しますか?
Remove test database and access to it? (Press y|Y for Yes, any other key for No) :

#Reloading the privilege tables will ensure that all changes
#made so far will take effect immediately.

#権威テーブルをリロードして、ここまでの設定を有効にしますか?
Reload privilege tables now? (Press y|Y for Yes, any other key for No) :

#成功、すべて完了!
#Success.
#All done!