{"id":236,"date":"2021-06-10T12:06:27","date_gmt":"2021-06-10T03:06:27","guid":{"rendered":"http:\/\/192.168.0.139:8080\/2021\/06\/10\/ubuntu%e3%81%abmysql-community-edition%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%97%e3%81%be%e3%81%99%e3%80%82\/"},"modified":"2021-06-10T12:06:27","modified_gmt":"2021-06-10T03:06:27","slug":"ubuntu%e3%81%abmysql-community-edition%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%97%e3%81%be%e3%81%99%e3%80%82","status":"publish","type":"post","link":"http:\/\/192.168.0.139:8080\/2021\/06\/10\/236\/","title":{"rendered":"ubuntu\u306bMySQL Community Edition\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002"},"content":{"rendered":"\n<p>\u4ee5\u524dRHEL8\u306bMySQL Community Edition\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f\u3002<br><a href=\"https:\/\/minokamo.tokyo\/2021\/04\/18\/3596\/\">https:\/\/minokamo.tokyo\/2021\/04\/18\/3596\/<\/a><br>\u672c\u65e5\u306f\u3001ubuntu\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\u516c\u5f0f\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<br><a href=\"https:\/\/dev.mysql.com\/downloads\/\">https:\/\/dev.mysql.com\/downloads\/<\/a><br>OS\u304cubuntu\u306a\u306e\u3067MySQL APT repository\u306e\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/minokamo.xyz\/img\/blog\/2021\/06\/20210608.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><br>\u6b21\u306e\u30da\u30fc\u30b8\u3067Download\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u9032\u307f\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u767b\u9332\u3084\u30ed\u30b0\u30a4\u30f3\u3092\u3059\u308b\u3053\u3068\u306f\u305b\u305a\u3001\u300cNo thanks , just start my download.\u300d\u306e\u30ea\u30f3\u30af\u30a2\u30c9\u30ec\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u304b\u3089\u306f\u30af\u30e9\u30a6\u30c9\u3084\u30ed\u30fc\u30ab\u30eb\u306a\u3069\u306b\u4f5c\u6210\u3057\u305fubuntu\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u306b\u3088\u308b\u64cd\u4f5c\u306b\u306a\u308a\u307e\u3059\u3002\u5148\u307b\u3069\u53d6\u5f97\u3057\u305f\u30ea\u30f3\u30af\u30a2\u30c9\u30ec\u30b9\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304b\u3089\u3001deb\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wget https:\/\/dev.mysql.com\/get\/mysql-apt-config_0.8.17-1_all.deb\nsudo dpkg -i .\/mysql-apt-config_0.8.17-1_all.deb<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/minokamo.xyz\/img\/blog\/2021\/06\/202106081.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Package configuration\u306e\u30ab\u30e9\u30fc\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u3069\u308c\u3082cluster\u3067\u306f\u306a\u304fServer\u3092\u9078\u629e\u3057\u3066\u9032\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/minokamo.xyz\/img\/blog\/2021\/06\/202106082.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><br>\u3053\u308c\u3067community server\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u6e96\u5099\u304c\u6574\u3044\u307e\u3057\u305f\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<br>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9014\u4e2d\u3067\u30ab\u30e9\u30fc\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6c7a\u3081\u307e\u3059\u3002\u300cSelect default authentication plugin\u300d\u3068\u805e\u304b\u308c\u305f\u306e\u3067\u300cUse Legacy Authentication Method\u300d\u3092\u9078\u629e\u3057\u307e\u3057\u305f\u3002\u30c6\u30b9\u30c8\u74b0\u5883\u306a\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u6642\u306b\u8907\u96d1\u306a\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u4f7f\u7528\u3092\u907f\u3051\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt-get install mysql-community-server<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/minokamo.xyz\/img\/blog\/2021\/06\/202106083.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b8c\u4e86\u5f8c\u306b\u3001\u521d\u671f\u8a2d\u5b9a\u3092\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/bin\/mysql_secure_installation<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>Securing the MySQL server deployment.\n\nEnter password for user root:\n\nVALIDATE PASSWORD COMPONENT can be used to test passwords\nand improve security. It checks the strength of password\nand allows the users to set only those passwords which are\nsecure enough. Would you like to setup VALIDATE PASSWORD component?\n\nPress y|Y for Yes, any other key for No: y\n\nThere are three levels of password validation policy:\n\nLOW    Length &gt;= 8\nMEDIUM Length &gt;= 8, numeric, mixed case, and special characters\nSTRONG Length &gt;= 8, numeric, mixed case, special characters and dictionary                  file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2\nUsing existing password for root.\n\nEstimated strength of the password: 25\nChange the password for root ? ((Press y|Y for Yes, any other key for No) : n\n\n ... skipping.\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\n - Dropping test database...\nSuccess.\n\n - Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nAll done!<\/code><\/pre>\n\n\n\n<p>\u6700\u5f8c\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"ubuntu\u306bMySQL Community Edition\u306e\u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KaqPXmZWUy0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u524dRHEL8\u306bMySQL Community Edition\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f\u3002https:\/\/minokamo.tokyo\/2021\/04\/18\/3596\/\u672c\u65e5\u306f\u3001ubuntu\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\u516c\u5f0f\u30ea\u30dd\u30b8\u30c8\u30ea [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/posts\/236"}],"collection":[{"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/comments?post=236"}],"version-history":[{"count":0,"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/posts\/236\/revisions"}],"wp:attachment":[{"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/media?parent=236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/categories?post=236"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/192.168.0.139:8080\/wp-json\/wp\/v2\/tags?post=236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}