{"id":2248,"date":"2018-10-07T17:27:37","date_gmt":"2018-10-07T10:27:37","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=2248"},"modified":"2025-03-26T23:11:46","modified_gmt":"2025-03-26T16:11:46","slug":"install-dan-amankan-phpmyadmin-di-apache-centos-7","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/","title":{"rendered":"Install dan Amankan phpMyAdmin di Apache CentOS 7"},"content":{"rendered":"<p>phpMyAdmin adalah alat\u00a0open source berbasis PHP untuk mengelola server MySQL dan MariaDB melalui antarmuka berbasis web.<\/p>\n<p>phpMyAdmin memungkinkan Anda untuk berinteraksi dengan database MySQL, mengelola akun dan hak istimewa pengguna, menjalankan pernyataan SQL, mengimpor dan mengekspor data dalam berbagai format data dan banyak lagi.<\/p>\n<p>Dalam tutorial ini, kita akan membahas langkah-langkah yang diperlukan untuk menginstal dan mengamankan phpMyAdmin dengan Apache pada CentOS 7.<\/p>\n<h2>Prasyarat<\/h2>\n<p>Pastikan Anda telah memenuhi prasyarat berikut sebelum melanjutkan dengan tutorial ini:<\/p>\n<ul>\n<li>LAMP (<a href=\"https:\/\/www.linuxid.net\/25357\/tutorial-singkat-install-lamp-stack-di-centos-7\/\">Linux, Apache, MySQL, dan PHP<\/a>) terinstal pada server CentOS.<\/li>\n<li>Masuk sebagai pengguna dengan<a href=\"https:\/\/www.linuxid.net\/25222\/cara-membuat-user-sudo-di-centos\/\"> hak istimewa sudo.<\/a><\/li>\n<\/ul>\n<h2>Instal phpMyAdmin<\/h2>\n<p>Untuk menginstal phpMyAdmin pada sistem CentOS 7 lakukan langkah-langkah berikut:<\/p>\n<ol>\n<li>phpMyAdmin tidak tersedia di repositori inti CentOS 7. Untuk menginstal phpMyAdmin kita harus mengaktifkan <a href=\"https:\/\/www.linuxid.net\/25658\/cara-menambahkan-epel-repository-di-centos\/\">repositori EPEL<\/a> terlebih dahulu:\n<pre>sudo yum install epel-release<\/pre>\n<\/li>\n<li>Setelah repositori EPEL diaktifkan, kita dapat menginstal phpMyAdmin dan semua dependensinya dengan perintah berikut:\n<pre>sudo yum install phpmyadmin<\/pre>\n<\/li>\n<\/ol>\n<h2>Mengkonfigurasi dan Mengamankan phpMyAdmin<\/h2>\n<p>File konfigurasi Apache untuk phpMyAdmin dibuat secara otomatis selama instalasi. Secara default semua koneksi kecuali yang dari localhost akan ditolak.<\/p>\n<p>Karena kita akan mengakses phpMyAdmin dari Internet, kita perlu memodifikasi file konfigurasi dan menentukan alamat IP yang diizinkan.<\/p>\n<p>Buka file konfigurasi Apache phpMyAdmin:<\/p>\n<pre>sudo nano \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/pre>\n<p>Ubah dua baris yang bertuliskan <code>Require ip 127.0.0.1<\/code> dengan koneksi alamat IP rumah Anda. Jika Anda tidak tahu alamat IP rumah Anda, buka Google di browser web dan ketik <code>what is my ip<\/code>.<\/p>\n<pre># Apache 2.4\r\n&lt;RequireAny&gt;\r\n\u00a0   #Require all granted\u00a0\u00a0#Untuk izinkan akses dari manapun \r\n    <span style=\"background-color: #ffff99;\">Require ip 192.168.42.57 #opsi tambahan<\/span>\r\n    Require ip ::1\r\n&lt;\/RequireAny&gt;<\/pre>\n<p>Tutup dan simpan file.<\/p>\n<p>Jika Anda ingin dapat mengakses instalasi phpMyAdmin dari lokasi mana saja di Internet, tambahkan atau hilangkan tagar (<code>#<\/code>) sebelum\u00a0<code>Require all granted<\/code> sebelum baris <code>Require ip<\/code>.<\/p>\n<p>Untuk lapisan keamanan tambahan, kita akan melindungi kata sandi direktori phpMyAdmin dengan menyiapkan otentikasi dasar.<\/p>\n<p>Mulailah dengan membuat file otentikasi baru menggunakan alat <code>htpasswd<\/code>. Kami akan menyimpan file <code>.htpasswd<\/code> di direktori <code>\/etc\/phpMyAdmin<\/code>:<\/p>\n<pre>sudo htpasswd -c \/etc\/phpMyAdmin\/.htpasswd admin<\/pre>\n<p>Dalam contoh ini kami membuat pengguna dengan\u00a0username\u00a0<code>admin<\/code>. Anda dapat memilih username apapun yang Anda inginkan.<\/p>\n<p>Perintah di atas akan meminta Anda untuk memasukkan dan mengonfirmasi kata sandi pengguna.<\/p>\n<pre>New password: \r\nRe-type new password: \r\nAdding password for user admin<\/pre>\n<p>Kemudian, jika Anda perlu menambahkan pengguna tambahan, gunakan perintah yang sama tanpa tanda <code>-c<\/code>:<\/p>\n<pre>sudo htpasswd \/etc\/phpMyAdmin\/.htpasswd <span style=\"color: #ff0000;\">adminlain<\/span><\/pre>\n<p>Langkah selanjutnya adalah mengkonfigurasi Apache agar dapat melindungi direktori phpMyAdmin dengan kata sandi\u00a0dan menggunakan <code>.htpasswd<\/code> . Untuk melakukannya, buka file <code>phpMyAdmin.conf<\/code> yang secara otomatis dibuat selama instalasi phpMyAdmin:<\/p>\n<pre>sudo nano \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/pre>\n<p>Dan masukkan garis-garis berikut yang disorot dengan warna kuning:<\/p>\n<pre>&lt;Directory \/usr\/share\/phpMyAdmin\/&gt;\r\n    AddDefaultCharset UTF-8\r\n\r\n<span style=\"background-color: #ffff99;\">    Options  +FollowSymLinks +Multiviews +Indexes\r\n    AllowOverride None\r\n    AuthType basic\r\n    AuthName \"Authentication Required\"\r\n    AuthUserFile \/etc\/phpMyAdmin\/.htpasswd\r\n    Require valid-user<\/span>\r\n\r\n   &lt;IfModule mod_authz_core.c&gt;\r\n   ...<\/pre>\n<p>Simpan file dan mulai ulang layanan Apache agar perubahan diterapkan:<\/p>\n<pre>sudo systemctl restart httpd<\/pre>\n<p>Demi alasan keamanan, disarankan untukk mengubah alias <code>\/phpmyadmin<\/code> menjadi nama lain yang lebih unik dan aman.<\/p>\n<p>Saat mengakses phpMyAdmin Anda, Anda akan diminta untuk memasukkan kredensial masuk pengguna yang sebelumnya Anda buat:<\/p>\n<pre>https:\/\/domain_atau_alamat_ip\/phpmyadmin<\/pre>\n<p>Setelah memasukkan otentikasi dasar, Anda akan dibawa ke halaman login phpMyAdmin tempat Anda harus memasukkan kredensial login pengguna administratif untuk MySQL Anda.<\/p>\n<h2>Mengakses phpMyAdmin<\/h2>\n<p>Untuk mengakses antarmuka phpMyAdmin buka browser dan ketikkan nama domain server Anda atau alamat IP publik diikuti oleh <code>\/phpmyadmin<\/code>:<\/p>\n<pre>https:\/\/your_domain_or_ip_address\/phpmyadmin<\/pre>\n<p><a href=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-basic-auth.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" td-modal-image alignnone wp-image-25813 size-large\" src=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-basic-auth-750x194.jpg\" alt=\"phpmyadmin basic auth\" width=\"696\" height=\"180\" \/><\/a><\/p>\n<p>Masukkan kredensial login pengguna administratif yang Anda buat sebelumnya dan klik <code>Go<\/code>.<\/p>\n<p><a href=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-login.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" td-modal-image alignnone wp-image-25814 size-large\" src=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-login-750x442.jpg\" alt=\"phpmyadmin login\" width=\"696\" height=\"410\" \/><\/a><\/p>\n<p>Setelah masuk, Anda akan melihat dasbor phpMyAdmin, yang akan terlihat seperti ini:<\/p>\n<p><a href=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-dasboard.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" td-modal-image alignnone wp-image-25815 size-large\" src=\"https:\/\/www.linuxid.net\/assets\/media\/how-to\/tutorial\/25355\/phpmyadmin-dasboard-750x713.jpg\" alt=\"phpmyadmin dasboard\" width=\"696\" height=\"662\" \/><\/a><\/p>\n<h2>Kesimpulan<\/h2>\n<p>Selamat, Anda telah berhasil menginstal phpMyAdmin di server CentOS 7 Anda. Anda sekarang dapat mulai <a href=\"https:\/\/www.linuxid.net\/25172\/tutorial-manajemen-database-mysql-dari-baris-perintah\/\">membuat database MySQL<\/a>, pengguna dan tabel dan melakukan berbagai permintaan dan operasi MySQL.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin adalah alat\u00a0open source berbasis PHP untuk mengelola server MySQL dan MariaDB melalui antarmuka berbasis&hellip;<\/p>\n","protected":false},"author":2,"featured_media":2249,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[38,15,77,44,171],"class_list":["post-2248","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-apache","tag-centos","tag-centos-7","tag-cms","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin adalah alat\u00a0open source berbasis PHP untuk mengelola server MySQL dan MariaDB melalui antarmuka berbasis&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-07T10:27:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-26T16:11:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"834\" \/>\n\t<meta property=\"og:image:height\" content=\"404\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/\",\"name\":\"Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg\",\"datePublished\":\"2018-10-07T10:27:37+00:00\",\"dateModified\":\"2025-03-26T16:11:46+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg\",\"width\":834,\"height\":404},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install dan Amankan phpMyAdmin di Apache CentOS 7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/","og_locale":"id_ID","og_type":"article","og_title":"Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid","og_description":"phpMyAdmin adalah alat\u00a0open source berbasis PHP untuk mengelola server MySQL dan MariaDB melalui antarmuka berbasis&hellip;","og_url":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/","og_site_name":"Linuxid","article_published_time":"2018-10-07T10:27:37+00:00","article_modified_time":"2025-03-26T16:11:46+00:00","og_image":[{"width":834,"height":404,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/","url":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/","name":"Install dan Amankan phpMyAdmin di Apache CentOS 7 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg","datePublished":"2018-10-07T10:27:37+00:00","dateModified":"2025-03-26T16:11:46+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-phpMyAdmin-di-CentOS.jpg","width":834,"height":404},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/install-dan-amankan-phpmyadmin-di-apache-centos-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Install dan Amankan phpMyAdmin di Apache CentOS 7"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=2248"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2248\/revisions"}],"predecessor-version":[{"id":2429,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/2248\/revisions\/2429"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/2249"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=2248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=2248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=2248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}