{"id":2323,"date":"2019-02-02T13:05:52","date_gmt":"2019-02-02T04:05:52","guid":{"rendered":"https:\/\/east19-mikas.com\/?page_id=2323"},"modified":"2024-08-20T14:49:36","modified_gmt":"2024-08-20T05:49:36","slug":"phpmyadmin","status":"publish","type":"page","link":"https:\/\/east19-mikas.com\/mpat\/?page_id=2323","title":{"rendered":"phpMyAdmin"},"content":{"rendered":"\n

phpMyAdmin \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n\n\n\n

phpMyAdmin \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h2>\n\n\n\n

\u6e96\u5099\u3068\u6761\u4ef6<\/h3>\n\n\n\n

[1] \u4e8b\u524d\u306b Apache httpd \u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u8d77\u52d5\u3057\u3066\u304a\u304d\u307e\u3059\u3002
[2] \u4e8b\u524d\u306b PHP \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\u307e\u3059\u3002
[3] \u4e8b\u524d\u306b MySQL \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\u307e\u3059\u3002
[4] phpMyAdmin \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u30ea\u30dd\u30b8\u30c8\u30ea\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3086\u304d\u307e\u3059<\/h3>\n\n\n\n

# EPEL, Remi<\/span> \u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
# yum<\/span> –enablerepo=remi -y install php70-php-mysql php70-php-mcrypt<\/span>
# yum<\/span> –enablerepo=epel -y install phpMyAdmin<\/span><\/p>\n\n\n\n

\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4\u30fb\u8ffd\u8a18<\/h3>\n\n\n\n

# vi<\/span> \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/span>

# 17, 34\u884c\u76ee\uff1a\u30a2\u30af\u30bb\u30b9\u8a31\u53efIP\u8ffd\u8a18
Require ip 127.0.0.1 10.0.0.0\/24<\/span><\/p>\n\n\n\n

Apache\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059<\/h3>\n\n\n\n

# systemctl<\/span> restart httpd<\/span><\/p>\n\n\n\n

\u52d5\u4f5c\u78ba\u8a8d<\/h3>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

[5] httpd \u3067\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u3057\u305f\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u5185\u306e\u4efb\u610f\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3067 Web \u30d6\u30e9\u30a6\u30b6\u3092\u8d77\u52d5\u3057\u3001[http:\/\/(\u30db\u30b9\u30c8\u540d\u307e\u305f\u306fIP\u30a2\u30c9\u30ec\u30b9)\/phpmyadmin\/] \u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3059\u308b\u3068 phpMyAdmin \u306e\u8a8d\u8a3c\u30d5\u30a9\u30fc\u30e0\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001MySQL \u306b\u767b\u9332\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u3067\u8a8d\u8a3c\u3057\u3066\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002\u5f53\u4f8b\u3067\u306f root \u30e6\u30fc\u30b6\u30fc\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002

 <\/p>\n\n\n\n

\u64cd\u4f5c\u753b\u9762<\/h3>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

[6] \u30ed\u30b0\u30a4\u30f3\u3067\u304d\u307e\u3057\u305f\u3002\u3053\u306e\u7ba1\u7406\u753b\u9762\u304b\u3089 MySQL\u3084MariaDB \u3092\u64cd\u4f5c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002

 <\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

phpMyAdmin \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb phpMyAdmin \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b \u6e96\u5099\u3068\u6761\u4ef6 [1] \u4e8b\u524d\u306b Apache httpd \u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u8d77\u52d5\u3057\u3066\u304a\u304d\u307e\u3059\u3002[2] \u4e8b\u524d\u306b PHP \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066 […]<\/p>\n","protected":false},"author":1,"featured_media":7886,"parent":1824,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-2323","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/pages\/2323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2323"}],"version-history":[{"count":2,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/pages\/2323\/revisions"}],"predecessor-version":[{"id":8641,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/pages\/2323\/revisions\/8641"}],"up":[{"embeddable":true,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/pages\/1824"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=\/wp\/v2\/media\/7886"}],"wp:attachment":[{"href":"https:\/\/east19-mikas.com\/mpat\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}