MySQLã® mysql_secure_installation ãŒä¸èº«ã§ã‚„ã£ã¦ã„ã‚‹ã“ã¨ã€‚yum install mysql-serverãªã‚“ã‹ã‚’ãŸãŸã„ãŸã‚ã¨ã§ã€æ‰‹å‹•ã§mysql_secure_installationを実行ã—ã¦ãŸã®ã‚’自動化ã™ã‚‹ã¨ãã®ãŸã‚ã®ãƒ¡ãƒ¢ã€‚ # MySQL 5.1åŒæ¢±ã®ã‚‚ã®ã®ä¸èº«ã‚’見ã¦è»¢è¨˜ã—ãŸã ã‘ã§ã™ãŒã€‚ â—‹rootユーザã®ãƒ‘スワード文å—列をè¨å®šã™ã‚‹ -- SET ROOT PASSWORD -- UPDATE mysql.user SET Password=PASSWORD('[パスワード文å—列]') WHERE User='root'; â—‹anonymousユーザを削除ã™ã‚‹ -- REMOVE ANONYMOUS USERS -- DELETE FROM mysql.user WHERE User=''; ○リモートã‹ã‚‰ã®rootãƒã‚°ã‚¤ãƒ³ã‚’ç¦æ¢ã™ã‚‹ -- REMOVE REMOTE ROOT -- DELETE FROM mysql.user WHER
mysql_secure_installationを試ã—ã¦ã¿ã‚‹ - yk5656 diary (æ—§)
{{#tags}}- {{label}}
{{/tags}}