{"id":1320,"date":"2019-05-11T20:22:03","date_gmt":"2019-05-11T11:22:03","guid":{"rendered":"http:\/\/wp.ultimai.org\/wp\/?p=1320"},"modified":"2019-05-22T18:35:52","modified_gmt":"2019-05-22T09:35:52","slug":"ubuntu-18-04-lts-mysql-server","status":"publish","type":"post","link":"http:\/\/wp.ultimai.org\/?p=1320","title":{"rendered":"Ubuntu 18.04 LTS \u306bMySQL Server\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"<h3>Ubuntu 18.04\u306bMySQL 5.7\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001root\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3059\u308b\u3068\u3053\u308d\u307e\u3067\u3002<\/h3>\n<h4>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h4>\n<p>apt\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<br \/>\n<input  class=\"tarminal-copy\" value=\"sudo apt install mysql-server -y\" readonly><br \/>\n\u4ee5\u524d\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d\u306broot\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u5165\u529b\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u305f\u3068\u601d\u3044\u307e\u3059\u304c\u3001<br \/>\n\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u306d\u3002<\/p>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5f8c\u3001\u300cmysql_secure_installation\u300d\u3092\u5b9f\u884c\u3057\u3066root\u306e<br \/>\n\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br \/>\n<input  class=\"tarminal-copy\" value=\"sudo mysql_secure_installation\" readonly><\/p>\n<p><em>\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408\u306f\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u7167<\/em><br \/>\n<a href=\"https:\/\/tech.librastudio.co.jp\/index.php\/2017\/07\/12\/post-1595\/\" >MySQL\u3067mysqld.sock\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u305f <\/a><\/p>\n<p>\u6700\u521d\u306b\u300cVALIDATE PASSWORD PLUGIN\u300d\u3092\u4f7f\u7528\u3059\u308b\u304b\u306e\u78ba\u8a8d\u3067\u3059\u3002<br \/>\n<em> \u30d1\u30b9\u30ef\u30fc\u30c9\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u4f7f\u7528\u3057\u3066\u5f37\u56fa\u306a\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5f37\u5236\u3059\u308b\u304b?<br \/>\n  <br \/>  \u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u306a\u306e\u3067 n \u3067\u3044\u3044<\/em><\/p>\n<pre class=\"tarminal\">Securing the MySQL server deployment.\r\nConnecting to MySQL using a blank password.\r\nVALIDATE PASSWORD PLUGIN can be used to test passwords\r\nand improve security. It checks the strength of password\r\nand allows the users to set only those passwords which are\r\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?Press y|Y for Yes, any other key for No: n<\/pre>\n<p>root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"tarminal\">Please set the password for root here.\r\nNew password: [\u8a2d\u5b9a\u3059\u308b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b]\r\nRe-enter new password: [\u8a2d\u5b9a\u3059\u308b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u518d\u5165\u529b]\r\nEstimated strength of the password: 100\r\nDo you wish to continue with the password provided?(Press y|Y for Yes, an\r\ny other key for No) : y<\/pre>\n<p>anonymous\u30e6\u30fc\u30b6\u30fc\u3092\u524a\u9664\u3059\u308b\u304b\u3002<br \/>\n\u5229\u7528\u3057\u306a\u3044\u306e\u3067y\u3092\u9078\u629e\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"tarminal\">By default, a MySQL installation has an anonymous user,\r\nallowing anyone to log into MySQL without having to have\r\na user account created for them. This is intended only for\r\ntesting, and to make the installation go a bit smoother.\r\nYou should remove them before moving into a production\r\nenvironment.\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : ySuccess.<\/pre>\n<p>root\u3067\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u53ef\u80fd\u3068\u3059\u308b\u304b\u3002<br \/>\n\u300cy\u300d\u3067\u63a5\u7d9a\u4e0d\u53ef\u3068\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"tarminal\">Normally, root should only be allowed to connect from\r\n'localhost'. This ensures that someone cannot guess at\r\nthe root password from the network.\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.<\/pre>\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u300ctest\u300d\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\u304b\u3002<br \/>\n\u300cy\u300d\u3067\u524a\u9664\u3092\u9078\u629e\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"tarminal\">By default, MySQL comes with a database named 'test' that\r\nanyone can access. This is also intended only for testing,\r\nand should be removed before moving into a production\r\nenvironment.\r\nRemove test database and access to it? (Press y|Y for Yes, any other key f\r\nor No) : y\r\n- Dropping test database...\r\nSuccess.\r\n- Removing privileges on test database...\r\nSuccess.<\/pre>\n<p>\u30c6\u30fc\u30d6\u30eb\u3092\u30ea\u30ed\u30fc\u30c9\u3059\u308b\u304b\u3002<br \/>\n\u300cy\u300d\u3067\u30ea\u30ed\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"tarminal\">Reloading the privilege tables will ensure that all changes\r\nmade so far will take effect immediately.\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\r\nSuccess<\/pre>\n<p>\u8d77\u52d5\u3059\u308b<br \/>\n<input  class=\"tarminal-copy\" value=\"sudo service mysql start\" readonly><\/p>\n<p>root\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b<br \/>\n<input  class=\"tarminal-copy\" value=\"sudo mysql -uroot -p\" readonly><\/p>\n<p>\u30ed\u30b0\u30a2\u30a6\u30c8\u3059\u308b<\/p>\n<pre class=\"tarminal\"> \\q <\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ubuntu 18.04\u306bMySQL 5.7\u3092\u30a4\u30f3 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[37],"class_list":["post-1320","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-wsl"],"_links":{"self":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1320"}],"version-history":[{"count":3,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1320\/revisions"}],"predecessor-version":[{"id":1379,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1320\/revisions\/1379"}],"wp:attachment":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1320"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}