mysql:mysql_secure_installation

差分

このページの2つのバージョン間の差分を表示します。

この比較画面へのリンク

--- mysql:mysql_secure_installation [2014/02/26 08:26] – clownclown
+++ mysql:mysql_secure_installation [2025/02/16 13:53] (現在) – 外部編集 127.0.0.1
@@ 行 1: / 行 1: @@
-===== mysql_secure_installation =====
+====== mysql_secure_installation ======
-  * set_root_password
+Set root password? [Y/n]
-UPDATE mysql.user SET Password=PASSWORD('$esc_pass') WHERE User='root';
+> UPDATE mysql.user SET Password=PASSWORD('$esc_pass') WHERE User='root';
-  * remove_anonymous_users
+Remove anonymous users? [Y/n]
-DELETE FROM mysql.user WHERE User='';
+> DELETE FROM mysql.user WHERE User='';
-  * remove_remote_root
+Disallow root login remotely? [Y/n]
-DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
+> DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
-  * remove_test_database
+Remove test database and access to it? [Y/n]
-DROP DATABASE test;
+> DROP DATABASE test;
-DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'
+> DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'
-  * reload_privilege_tables
+Reload privilege tables now? [Y/n]
-FLUSH PRIVILEGES;
+> FLUSH PRIVILEGES;

mysql/mysql_secure_installation.1393403173.txt.gz · 最終更新: 2025/02/16 13:50 (外部編集)