{"id":2862,"date":"2019-05-07T21:34:11","date_gmt":"2019-05-07T18:34:11","guid":{"rendered":"https:\/\/kifarunix.com\/?p=2862"},"modified":"2019-05-08T09:55:03","modified_gmt":"2019-05-08T06:55:03","slug":"install-phpmyadmin-with-apache-on-fedora-30","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-phpmyadmin-with-apache-on-fedora-30\/","title":{"rendered":"Install phpMyAdmin with Apache on Fedora 30"},"content":{"rendered":"\n<p>In this guide, you are going to learn how to install phpMyAdmin with Apache on Fedora 30. <a rel=\"noreferrer noopener\" aria-label=\"phpMyAdmin (opens in a new tab)\" href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\">phpMyAdmin<\/a> is an open-source tool that is used to administer MySQL or MariaDB over the web. phpMyAdmin provides quite a number of features including but not limited to;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Intuitive web interface<\/li><li>Support for most MySQL features:<ul><li>browse and drop databases, tables, views, fields and indexes<\/li><li>create, copy, drop, rename and alter databases, tables, fields and indexes<\/li><li>maintenance server, databases and tables, with proposals on server configuration<\/li><li>execute, edit and bookmark any&nbsp;<abbr title=\"structured query language\">SQL<\/abbr>-statement, even batch-queries<\/li><li>manage MySQL user accounts and privileges<\/li><li>manage stored procedures and triggers<\/li><\/ul><\/li><li>Import data from&nbsp;<abbr title=\"comma separated values\">CSV<\/abbr>&nbsp;and&nbsp;<abbr title=\"structured query language\">SQL<\/abbr><\/li><li>Export data to various formats:&nbsp;<abbr title=\"comma separated values\">CSV<\/abbr>,&nbsp;<abbr title=\"structured query language\">SQL<\/abbr>,&nbsp;<abbr title=\"Extensible Markup Language\">XML<\/abbr>,&nbsp;<abbr title=\"Portable Document Format\">PDF<\/abbr>,&nbsp;<abbr title=\"International Organization for Standards\">ISO<\/abbr>\/<abbr title=\"International Electrotechnical Commission\">IEC<\/abbr>&nbsp;26300 &#8211; OpenDocument Text and Spreadsheet,&nbsp;<abbr title=\"Microsoft Word 2000\">Word<\/abbr>, L<sup>A<\/sup>T<sub><em>E<\/em><\/sub>X and others<\/li><li>Administering multiple servers<\/li><li>Creating graphics of your database layout in various formats<\/li><li>Creating complex queries using Query-by-example (QBE)<\/li><li>Searching globally in a database or a subset of it<\/li><li>Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Install phpMyAdmin with Apache on Fedora 30<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites<\/h3>\n\n\n\n<p>To install phpMyAdmin with Apache on Fedora 30, you need to have LAMP stack configured. To install LAMP stack on Fedora 30, follow the link below;<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"https:\/\/kifarunix.com\/install-lamp-stack-on-fedora-30\/\" target=\"_blank\">Install LAMP Stack on Fedora 30<\/a><\/p>\n\n\n\n<p>Once you have the LAMP stack installed, proceed to install phpMyAdmin on Fedora 30. The good news is that phpMyAdmin is available on the default Fedora repositories and thus can simply be installed using the DNF package manager. The latest staple release of phpMyAdmin is v4.8.5. To verify if this version is available on the default Fedora repos;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>dnf provides phpmyadmin<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>phpMyAdmin-4.8.5-2.fc30.noarch : Handle the administration of MySQL over the World Wide Web\nRepo        : fedora\nMatched from:\nProvide    : phpmyadmin = 4.8.5-2.fc30<\/code><\/pre>\n\n\n\n<p>Hence, install phpMyAdmin by running the command below;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>dnf install phpmyadmin<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Configure phpMyAdmin to Allow Remote Access<\/h3>\n\n\n\n<p>Once the installation is done, proceed to configure phpMyAdmin to allow remote access. By default, phpMyAdmin only allows access from the localhost. When installation is done, default Apache phpMyAdmin configuration file is created under, <code>\/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/code>.<\/p>\n\n\n\n<p>To configure phpMyAdmin to allow external access, edit the configuration file and make the adjustments below;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>vim \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/code><\/pre>\n\n\n\n<p>Replace the loopback IP, <strong>127.0.0.1<\/strong> under the directives <strong>Require ip<\/strong> and <strong>allow from<\/strong> with the IP address of the server you want to access phpMyAdmin from.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>...\n   &lt;IfModule mod_authz_core.c>\n     # Apache 2.4\n     &lt;RequireAny>\n       Require ip 192.168.0.102\n       Require ip ::1\n     &lt;\/RequireAny>\n   &lt;\/IfModule>\n   &lt;IfModule !mod_authz_core.c>\n     # Apache 2.2\n     Order Deny,Allow\n     Deny from All\n     Allow from 192.168.0.102\n     Allow from ::1\n   &lt;\/IfModule>\n&lt;\/Directory>\n\n&lt;Directory \/usr\/share\/phpMyAdmin\/setup\/>\n   &lt;IfModule mod_authz_core.c>\n     # Apache 2.4\n     &lt;RequireAny>\n       Require ip 192.168.0.102\n       Require ip ::1\n     &lt;\/RequireAny>\n   &lt;\/IfModule>\n   &lt;IfModule !mod_authz_core.c>\n     # Apache 2.2\n     Order Deny,Allow\n     Deny from All\n     Allow from 192.168.0.102\n     Allow from ::1\n   &lt;\/IfModule>\n&lt;\/Directory>\n...<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Restart Apache<\/h3>\n\n\n\n<p>Once you done making the changes above, restart Apache.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>systemctl restart httpd<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Access phpMyAdmin from Browser<\/h3>\n\n\n\n<p>phpMyAdmin in its basic configuration is now ready for access from web. Use the link, <strong>http:\/\/server-IP\/phpMyAdmin<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-ui.png\"><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"479\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-ui.png\" alt=\" install phpMyAdmin with Apache on Fedora 30\" class=\"wp-image-2863\" title=\"\"><\/a><\/figure>\n\n\n\n<p><font style=\"vertical-align: inherit;\"><font style=\"vertical-align: inherit;\">You can login to phpMyAdmin using MaraiDB\/MySQL the root user credentials. If connection is successful, you will land on the phpMyAdmin dashboard.<\/font><\/font><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-dashbaord.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1333\" height=\"602\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-dashbaord.png\" alt=\"phpmyadmin dashboard\" class=\"wp-image-2864\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-dashbaord.png 1333w, https:\/\/kifarunix.com\/wp-content\/uploads\/2019\/05\/phpmyadmin-dashbaord-768x347.png 768w\" sizes=\"(max-width: 1333px) 100vw, 1333px\" \/><\/a><\/figure>\n\n\n\n<p><font style=\"vertical-align: inherit;\"><font style=\"vertical-align: inherit;\">Well, you have successfully installed phpMyAdmin with Apache on Fedora 30. You can now perform any database administration task as you would from the backend. Enjoy.<\/font><\/font><\/p>\n\n\n\n<p>Want to run phpMyAdmin with Nginx? check the link below;<\/p>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/install-phpmyadmin-with-nginx-on-fedora-30\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Install phpMyAdmin with Nginx on Fedora 30<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, you are going to learn how to install phpMyAdmin with Apache on Fedora 30. phpMyAdmin is an open-source tool that is used<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[299,928,929,938],"tags":[924,136,135,281],"class_list":["post-2862","post","type-post","status-publish","format-standard","hentry","category-database","category-mariadb","category-mysql","category-phpmyadmin","tag-fedora-30","tag-mariadb","tag-mysql","tag-phpmyadmin","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/2862"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=2862"}],"version-history":[{"count":3,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/2862\/revisions"}],"predecessor-version":[{"id":2873,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/2862\/revisions\/2873"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=2862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=2862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=2862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}