{"id":8521,"date":"2019-07-25T01:41:19","date_gmt":"2019-07-25T01:41:19","guid":{"rendered":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/?p=8521"},"modified":"2019-07-25T04:18:19","modified_gmt":"2019-07-25T04:18:19","slug":"ubuntu18-04%e3%81%a7mysql%e3%82%92%e5%88%a9%e7%94%a8%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/?p=8521","title":{"rendered":"xubuntu18.04\u3067MySQL\u3092\u5229\u7528\u3059\u308b"},"content":{"rendered":"<p>\u3000xubuntu 18.04 \u3067 MySQL \u3092\u5229\u7528\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\uff0c\u304b\u306a\u308a\u5909\u5316\u3057\u3066\u3044\u3066\u6238\u60d1\u3044\u307e\u3057\u305f\u3002\u5148\u65e5\u3082\uff0c\u958b\u767a\u30c4\u30fc\u30eb\u306a\u3093\u304b\u304c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u5165\u3063\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u306b\u9a5a\u304d\u307e\u3057\u305f\u3051\u3069\uff0c\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u306b\u3082\u9055\u3044\u304c\u3042\u308b\u3068\u306f\u601d\u308f\u306a\u304b\u3063\u305f\u3002<\/p>\n<p>synaptic \u3067 apache2\uff0cphp\uff0cmysql-server\uff0cmysql-client\uff0cphpmyadmin \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u5b9a\u306b\u95a2\u3059\u308b\u53c2\u8003\u30b5\u30a4\u30c8\u306f\u4e0b\u8a18\u3067\u3059\u3002<\/p>\n<ul><a href=\"https:\/\/beautifulajax.dip.jp\/?p=1825\">Ubuntu 18.04 \u306b nginx mysql php phpmyadmin\u74b0\u5883\u3092\u6574\u3048\u308b<\/a><\/ul>\n<p>\u3084\u3063\u305f\u3053\u3068\u306f\u53c2\u8003\u30b5\u30a4\u30c8\u305d\u306e\u307e\u307e\u3067\u3059\u304c\uff0c\u4e0b\u8a18\u306b\u30b3\u30de\u30f3\u30c9\u3092\u8a18\u9332\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u4e00\u90e8\u30ec\u30b9\u30dd\u30f3\u30b9\u306f\u7701\u7565\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre><code style=\"color:midnightblue; font-size:12px;white-space:pre-wrap\">friend@xubuntu1804:~$ sudo mysql -u root\r\n[sudo] friend \u306e\u30d1\u30b9\u30ef\u30fc\u30c9: \r\nmysql> use mysql\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nmysql> update user set plugin='mysql_native_password' where User='root';\r\nQuery OK, 1 row affected (0.04 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n\r\nmysql> flush privileges;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql> exit;\r\nBye\r\nfriend@xubuntu1804:~$ mysql -u root\r\n\r\nmysql> set password for root@'localhost'=PASSWORD('\u30d1\u30b9\u30ef\u30fc\u30c9');\r\nQuery OK, 0 rows affected, 1 warning (0.02 sec)\r\n\r\nmysql> exit;\r\nBye\r\nfriend@xubuntu1804:~$ \r\n<\/code><\/pre>\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u95a2\u4fc2\u306e\u5909\u66f4\u306e\u3088\u3046\u3067\u3059\u3002\u4e0a\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u306f\u53e4\u3044\u30bf\u30a4\u30d7\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u51e6\u7406\u306b\u3059\u308b\u3068\u3044\u3046\u3082\u306e\u3089\u3057\u3044\u3002phpmyadmin \u304c\u65b0\u3057\u3044\u3082\u306e\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u53e4\u3044\u3082\u306e\u306b\u623b\u3059\u5fc5\u8981\u304c\u3042\u308b\u3089\u3057\u3044\u3002\u95a2\u9023\u8a18\u4e8b\u3078\u306e\u30ea\u30f3\u30af\u3092\u3042\u3052\u3068\u304d\u307e\u3059\u3002<\/p>\n<ul>\n<li><a href=\"https:\/\/yoku0825.blogspot.com\/2018\/01\/mysql-804.html\">MySQL 8.0.4\u306b\u304a\u3051\u308b\u30c7\u30d5\u30a9\u30eb\u30c8\u8a8d\u8a3c\u5f62\u5f0f\u306e\u5909\u66f4<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u3000xubuntu 18.04 \u3067 MySQL \u3092\u5229\u7528\u3057\u3088\u3046\u3068\u601d\u3063\u305f\u3089\uff0c\u304b\u306a\u308a\u5909\u5316 &#8230; <a class=\"more-link\" href=\"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/?p=8521\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-8521","post","type-post","status-publish","format-standard","hentry","category-column"],"_links":{"self":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8521"}],"version-history":[{"count":15,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8521\/revisions"}],"predecessor-version":[{"id":8536,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8521\/revisions\/8536"}],"wp:attachment":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8521"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}