{"id":1686,"date":"2022-03-01T09:46:57","date_gmt":"2022-03-01T00:46:57","guid":{"rendered":"https:\/\/www.next-hop.net\/blog\/hiraga\/?p=1686"},"modified":"2023-03-14T09:29:55","modified_gmt":"2023-03-14T00:29:55","slug":"install-mysql57","status":"publish","type":"post","link":"https:\/\/www.next-hop.net\/blog\/hiraga\/freebsd\/install-mysql57\/","title":{"rendered":"MySQL 5.7\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b"},"content":{"rendered":"<h3>\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\npkg install -y mysql57-server\r\nsysrc mysql_enable=YES\r\n<\/pre>\n<h3>\u8d77\u52d5<\/h3>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nservice mysql-server start\r\n<\/pre>\n<h3>root\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u5909\u66f4<\/h3>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nmysql -uroot -p`tail -1 \/root\/.mysql_secret | awk '{printf($0);}'`\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';\r\n<\/pre>\n<h3>root\u306e\u8ffd\u52a0<\/h3>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nCREATE USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password';\r\nCREATE USER 'root'@'::1' IDENTIFIED WITH mysql_native_password BY 'password';\r\nGRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';\r\nGRANT ALL PRIVILEGES ON *.* TO 'root'@'::1';\r\nUPDATE mysql.user SET grant_priv='Y' WHERE user='root';\r\nFLUSH PRIVILEGES;\\n&quot;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb pkg install -y mysql57-server sysrc mysql_enable=YES \u8d77\u52d5 service mysql-server start root\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u5909\u66f4 m\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.next-hop.net\/blog\/hiraga\/freebsd\/install-mysql57\/\">\u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1686","post","type-post","status-publish","format-standard","hentry","category-freebsd"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/posts\/1686"}],"collection":[{"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/comments?post=1686"}],"version-history":[{"count":18,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/posts\/1686\/revisions"}],"predecessor-version":[{"id":1814,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/posts\/1686\/revisions\/1814"}],"wp:attachment":[{"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/media?parent=1686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/categories?post=1686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.next-hop.net\/blog\/hiraga\/wp-json\/wp\/v2\/tags?post=1686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}