MySQLã®rootã®ãƒ‘スワードを忘れãŸå ´åˆã«å¤‰æ›´ã™ã‚‹æ–¹æ³•ãƒ¡ãƒ¢ - uncertain worldå‰ä»»ã®äººãŒrootã®ãƒ‘スワード残ã•ãªã„ã¾ã¾å±…ãªããªã£ã¦ã€ ã¨ã£ã¦ã‚‚å›°ã£ãŸã®ã§(grantã§ããªã„)〠åˆæœŸåŒ–ã™ã‚‹æ–¹æ³•è¦‹ã¦ãŸã‚“ã ã‘ã©ã€æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®ã˜ã‚ƒæ²»ã‚‰ãªãã¦ã€ 本家ã®æ–¹ã¿ãŸã‚‰æ²»ã£ãŸ > UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; > FLUSH PRIVILEGES; ã“ã‚Œã§MyNewPassã«æ–°ã—ã„パスワード入れれã°okã¿ãŸã„。 ・MySQL :: MySQL 5.1 Reference Manual :: B.1.4.1 How to Reset the Root Password http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html ・5/31追記 ãªãœã‹ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã«ä¸ŠãŒã£ã¦ã—ã¾ã£ã¦ã„ãŸã®ã§ã€ã¡ã‚‡ã£
{{#tags}}- {{label}}
{{/tags}}