{"id":486,"date":"2021-10-28T19:19:37","date_gmt":"2021-10-28T10:19:37","guid":{"rendered":"https:\/\/www.despina.work\/wordpress\/?page_id=486"},"modified":"2021-10-31T19:10:51","modified_gmt":"2021-10-31T10:10:51","slug":"phpmyadmin","status":"publish","type":"page","link":"https:\/\/www.despina.work\/wordpress\/?page_id=486","title":{"rendered":"phpMyAdmin"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>\u6a29\u9650\u3055\u3048\u4e0e\u3048\u3066\u3084\u308a\u3083\u307b\u304b\u306eDB\u898b\u308c\u308b\uff08\u5f53\u305f\u308a\u524d\uff09<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>##db\u4f5c\u6210\nmysql&gt;\nCREATE DATABASE XXXXXXdb;\nCREATE USER XXXXXXuser IDENTIFIED BY 'XXXXXX'; \nGRANT ALL ON XXXXXXdb.* TO XXXXXXuser;\nFLUSH PRIVILEGES;\n\n##server\u3082\u5165\u308c\u308b\u5834\u5408\u306f\u672c\u4f53\u3054\u3068\u5165\u308c\u308b\n\uff08\u4eca\u56de\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u307f\uff09\napt install mysql-client\n\n##\u672c\u4f53\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\napt install phpmyadmin\n\n##phpMyAdmin\u5074DB\u63a5\u7d9a\u8a2d\u5b9a\u3044\u3058\u308b\nvim \/etc\/phpmyadmin\/config-db.php\nvim \/etc\/dbconfig-common\/phpmyadmin.conf\n\n##apache2\u5074\u8a2d\u5b9a\nvim \/etc\/apache2\/conf-available\/phpmyadmin.conf\n\n######\u5185\u5bb9\u3053\u3053\u304b\u3089\uff08\u5168\u8a31\u53ef\uff09---\nInclude \/etc\/phpmyadmin\/apache.conf\n\n&lt;Directory \/usr\/share\/phpmyadmin&gt;\nOrder deny,allow\n&lt;\/Directory&gt;\n######---\u5185\u5bb9\u3053\u3053\u307e\u3067\n\n##\u8a2d\u5b9a\u9069\u7528\u3068\u30b5\u30fc\u30d3\u30b9\u518d\u8d77\u52d5\na2enconf phpmyadmin.conf\nsudo service apache2 restart\n<\/code><\/pre>\n\n\n\n<p>\u53c2\u8003\u30b5\u30a4\u30c8<\/p>\n\n\n\n<p><a href=\"https:\/\/www.yokoweb.net\/2020\/08\/16\/ubuntu-20_04-phpmyadmin-install\/\">\u3010Ubuntu 20.04 LTS Server\u3011phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb | The modern stone age. (yokoweb.net)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/penpen-dev.com\/blog\/phpmyadmin-ubuntu\/\">Ubuntu\u306bphpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u4f7f\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u307e\u3067\u306e\u624b\u9806 (penpen-dev.com)<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6a29\u9650\u3055\u3048\u4e0e\u3048\u3066\u3084\u308a\u3083\u307b\u304b\u306eDB\u898b\u308c\u308b\uff08\u5f53\u305f\u308a\u524d\uff09 \u53c2\u8003\u30b5\u30a4\u30c8 \u3010Ubuntu 20.04 LTS Server\u3011phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb | The modern stone age. (yokoweb.net [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-486","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=486"}],"version-history":[{"count":5,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/486\/revisions"}],"predecessor-version":[{"id":551,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/486\/revisions\/551"}],"wp:attachment":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}