{"height":"190","blog_title":"\u306d\u3053\u306b\u306a\u308a\u305f\u3044","author_url":"https://blog.hatena.ne.jp/Arpino/","url":"https://arpino.hatenadiary.com/entry/2021/08/16/122702","provider_url":"https://hatena.blog","published":"2021-08-16 12:27:02","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Farpino.hatenadiary.com%2Fentry%2F2021%2F08%2F16%2F122702\" title=\"mysql\u3064\u306a\u304c\u3089\u306d\u30a7\uff01 - \u306d\u3053\u306b\u306a\u308a\u305f\u3044\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":[],"title":"mysql\u3064\u306a\u304c\u3089\u306d\u30a7\uff01","blog_url":"https://arpino.hatenadiary.com/","version":"1.0","type":"rich","author_name":"Arpino","description":"\u300cAccess denied for user \u2018root\u2019@\u2019localhost\u2019\u300d\u304c\u51fa\u3066\u3001mysql\u5165\u308c\u306a\u3044\u5834\u5408\u306e\u30e1\u30e2\u3002 \u3053\u306e\u30b5\u30a4\u30c8\u304c\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002 blog.kuromusubi.com \u2460\u300cmysql server stop\u300d\u3067\u30b5\u30fc\u30d0\u3092\u6b62\u3081\u308b\u2461\u300cmysql -u root\u300d\u3067\u30eb\u30fc\u30c8\u6a29\u9650\u4f7f\u7528\u3057\u3066\u5165\u308b\u2462\u300cDROP USER root@localhost;\u300d\u3067\u65e2\u5b58\u306e\u30eb\u30fc\u30c8\u6a29\u9650\u3092\u6d88\u3059\u2463\u300cCREATE USER 'root'@'localhost' IDENTIFIED BY '*****';\u300d\u3067*****\u90e8\u5206\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u308c\u3066\u65b0\u898f\u30e6\u30fc\u30b6\u767b\u9332\u2464\u300cGRANT ALL P\u2026","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/A/Arpino/20210816/20210816123048.png","width":"100%"}