Skip to content

Instantly share code, notes, and snippets.

@bluerabbit
Created February 27, 2013 10:10
Show Gist options
  • Select an option

  • Save bluerabbit/5046843 to your computer and use it in GitHub Desktop.

Select an option

Save bluerabbit/5046843 to your computer and use it in GitHub Desktop.
MySQL Serverを最初に起動した時に実行すべきコマンド:mysql_secure_installation
%mysql_secure_installation
Change the root password? [Y/n] Y
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
  • rootパスワードを設定する
  • rootによるリモートのホストからのログインを禁止する
  • 匿名ユーザを削除する
  • どのユーザでも自由にアクセスできるtestデータベースを削除する
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment