{"id":16169,"date":"2019-03-25T09:14:07","date_gmt":"2019-03-25T09:14:07","guid":{"rendered":"https:\/\/www.hostinger.com\/tutorials\/?p=16169"},"modified":"2026-03-10T09:37:08","modified_gmt":"2026-03-10T09:37:08","slug":"how-to-install-phpmyadmin-on-centos","status":"publish","type":"post","link":"\/ph\/tutorials\/how-to-install-phpmyadmin-on-centos","title":{"rendered":"How to Install phpMyAdmin on CentOS 9 Stream"},"content":{"rendered":"<p>MySQL is a database that is popular above all kinds of developers! It&rsquo;s open source and maintains a perfect balance between speed and features. That&rsquo;s why in this tutorial, we&rsquo;ll show you how to install phpMyAdmin on CentOS 9 Stream &ndash; an amazing tool for MySQL database management. Your VPS will have an additional utility to increase the quality of life.<\/p><p>The main reason for having phpMyAdmin is that the native tool for accessing MySQL is the command line. Not everyone can access the command line at any point, and the lack of GUI &ndash; graphical user interface &ndash; can be a pain for novice users. phpMyAdmin supports a wide range of operations on MySQL and MariaDB (a fork of MySQL).<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/assets.hostinger.com\/content\/tutorials\/pdf\/Linux-Commands-Cheat-Sheet.pdf\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" width=\"1024\" height=\"283\" src=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/11\/Linux-cheat-sheet-1024x283.png\" alt=\"\" class=\"wp-image-69262\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2022\/11\/Linux-cheat-sheet-1536x425.png 1024w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2022\/11\/Linux-cheat-sheet-300x83.png 300w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2022\/11\/Linux-cheat-sheet-150x41.png 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2022\/11\/Linux-cheat-sheet-768x212.png 768w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2022\/11\/Linux-cheat-sheet.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div><p>\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-how-to-install-phpmyadmin-on-centos-9\">How to Install phpMyAdmin on CentOS 9<\/h2><p>Let&rsquo;s run down the step-by-step process of how to install phpMyAdmin on CentOS 9:<\/p><h3 class=\"wp-block-heading\" id=\"h-1-access-your-vps\">1. Access Your VPS<\/h3><p>Before we start, we&rsquo;ll need to access our VPS platform using SSH! If you&rsquo;re having trouble, check out our <a href=\"\/ph\/tutorials\/how-to-use-putty-ssh\">PuTTY tutorial<\/a>!<\/p><?xml encoding=\"utf-8\" ?><figure class=\"wp-block-image size-large\"><a href=\"\/ph\/vps-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2023\/02\/VPS-hosting-banner-1024x300.png\" alt=\"\" class=\"wp-image-77934\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2023\/02\/VPS-hosting-banner.png 1024w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2023\/02\/VPS-hosting-banner-300x88.png 300w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2023\/02\/VPS-hosting-banner-150x44.png 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2023\/02\/VPS-hosting-banner-768x225.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><h3 class=\"wp-block-heading\" id=\"h-2-install-an-apache-web-server-and-php\">2. Install an Apache Web Server and PHP<\/h3><p>The first prerequisite of phpMyAdmin is an Apache <a href=\"\/ph\/tutorials\/what-is-a-web-server\">web server<\/a>. Use the following command to install Apache on your CentOS 9 Stream virtual private server:<\/p><pre class=\"wp-block-preformatted\">yum install httpd -y<\/pre><p>Next, check the status of apache with the command:<\/p><pre class=\"wp-block-preformatted\">systemctl status httpd<\/pre><p>If you use Hostinger VPS, you can also check the status of apache by asking the<strong> <\/strong><a href=\"\/blog\/kodee\">Kodee AI assistant<\/a>. Simply enter, &ldquo;Check the HTTPD service status in my VPS&rdquo; and Kodee will output the service status and other important information. <\/p><div class=\"wp-block-image\"><figure data-wp-context='{\"imageId\":\"69eb94b0baa19\"}' data-wp-interactive=\"core\/image\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"344\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/kodee-checks-the-httpd-service-status-1024x344.png\" alt=\"Kodee checks the HTTP service status\" class=\"wp-image-124624\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/kodee-checks-the-httpd-service-status-1024x344.png 1024w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/kodee-checks-the-httpd-service-status-300x101.png 300w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/kodee-checks-the-httpd-service-status-150x50.png 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/kodee-checks-the-httpd-service-status-768x258.png 768w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/kodee-checks-the-httpd-service-status.png 1460w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure><\/div><p>Next, we should make sure that Apache is running. Enter your server&rsquo;s IP address into a browser address bar. You should see the Apache testing splash screen:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1179\" height=\"743\" src=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/apache-testing-spash-screen.jpg\" alt=\"Apache testing splash screen\" class=\"wp-image-16170\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen.jpg 1179w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen-150x95.jpg 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen-300x189.jpg 300w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen-768x484.jpg 768w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen-1024x645.jpg 1024w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/apache-testing-spash-screen-990x624.jpg 990w\" sizes=\"(max-width: 1179px) 100vw, 1179px\" \/><\/figure><\/div><p>Now that Apache is ready, go ahead and install PHP using the following commands:<\/p><pre class=\"wp-block-preformatted\">yum install php<\/pre><pre class=\"wp-block-preformatted\">systemctl restart httpd<\/pre><h3 class=\"wp-block-heading\" id=\"h-3-install-the-epel-repository\">3. Install the EPEL Repository<\/h3><p>phpMyAdmin comes in the EPEL repository (Extra Packages for Enterprise Linux). To access EPEL you need to install a special package &ndash; epel-release. Use the following command to install epel-release on your CentOS:<\/p><pre class=\"wp-block-preformatted\">sudo yum install epel-release<\/pre><p>Now that the EPEL repo is made available, we can proceed to install phpMyAdmin on CentOS 9.<\/p><h3 class=\"wp-block-heading\" id=\"h-4-install-phpmyadmin-on-centos-9-stream\">4. Install phpMyAdmin on CentOS 9 Stream<\/h3><p>Issue the following command:<\/p><pre class=\"wp-block-preformatted\">sudo yum install phpmyadmin<\/pre><p>Once the installation is complete, you will have to edit the phpMyAdmin configuration file.<\/p><h3 class=\"wp-block-heading\" id=\"h-5-configure-the-phpmyadmin-conf-file\">5. Configure the phpMyAdmin.conf File<\/h3><p>The edit will make sure that you can access your phpMyAdmin client remotely. We&rsquo;ll open the <strong>phpMyAdmin.conf<\/strong> file located in the directory <strong>\/etc\/httpd\/conf.d\/<\/strong> using the vim editor:<\/p><pre class=\"wp-block-preformatted\">vim \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/pre><p>Here you will see four different require ip strings matched with long IPs. The default value is <strong>127.0.0.1<\/strong>. Replace that value with the IP of the machine you will be using to access phpMyAdmin. You can use a tool like <a href=\"https:\/\/www.whatsmyip.org\/\" target=\"_blank\" rel=\"noopener\">WhatsMyIP<\/a> to check your IP. Save and exit the file by hitting <strong>escape<\/strong> and typing in <strong>:wq<\/strong>.<\/p><p>You can see an example of the <strong>phpMyAdmin<\/strong><strong>.conf<\/strong> file below:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"391\" height=\"305\" src=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/phpmyadmin-configuration-file.png\" alt=\"The phpMyAdmin configuration file opened using the vim editor\" class=\"wp-image-16171\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-configuration-file.png 391w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-configuration-file-150x117.png 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-configuration-file-300x234.png 300w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/figure><\/div><h3 class=\"wp-block-heading\" id=\"h-6-restart-the-apache-web-server\">6. Restart the Apache Web Server<\/h3><p>Next we&rsquo;ll restart the Apache web server by entering the following command in the command line:<\/p><pre class=\"wp-block-preformatted\">systemctl restart httpd<\/pre><h3 class=\"wp-block-heading\" id=\"h-7-check-if-phpmyadmin-is-working\">7. Check if phpMyAdmin is Working<\/h3><p>Finally, we can open phpMyAdmin utility by entering in your server&rsquo;s IP address in a browser&rsquo;s address bar with the addition <strong>\/<\/strong>phpmyadmin string like so &ndash; <strong>127.0.0.1\/phpmyadmin<\/strong>. There you should see the login screen.<\/p><h3 class=\"wp-block-heading\" id=\"h-8-locate-your-phpmyadmin-username-and-password\">8. Locate Your phpMyAdmin Username and Password<\/h3><p>Your username and password will be located in the file <strong>config.inc.php<\/strong>. The file will be in the phpMyAdmin installation directory. For us it is <strong>\/etc\/phpMyAdmin<\/strong>.<\/p><p>Open the file using the vim editor:<\/p><pre class=\"wp-block-preformatted\">vim config.inc.php<\/pre><p>Inside you can set the username and password, as shown in the screenshot below:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"356\" height=\"117\" src=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/phpmyadmin-user-configuration-file.png\" alt=\"The phpMyAdmin user configuration file opened in the vim editor\" class=\"wp-image-16172\" srcset=\"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-user-configuration-file.png 356w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-user-configuration-file-150x49.png 150w, https:\/\/www.hostinger.com\/ph\/tutorials\/wp-content\/uploads\/sites\/44\/2019\/03\/phpmyadmin-user-configuration-file-300x100.png 300w\" sizes=\"(max-width: 356px) 100vw, 356px\" \/><\/figure><\/div><p>Save and exit the file by hitting&nbsp;<strong>esc<\/strong> and <strong>:wq<\/strong> as before.<\/p><h2 class=\"wp-block-heading\" id=\"h-why-use-phpmyadmin\">Why Use phpMyAdmin?<\/h2><p>When you install phpMyAdmin on CentOS 9 Stream, you get to enjoy a new, intuitive user interface through your browser, instead of using the command line. Through this web interface, you can perform all the typical operations like managing databases, tables, columns, relations, users etc, while at the same being able to execute any SQL statement directly.<\/p><p>To increase its adoption rate, phpMyAdmin is translated into 72 different languages and supports both RTL (right-to-left) and LTR (left-to-right) &nbsp;languages.<\/p><p>Some other phpMyAdmin features:<\/p><ul class=\"wp-block-list\">\n<li>create, browse, edit, and drop databases, tables, views, columns, and indexes<\/li>\n\n\n\n<li>display multiple result sets through stored procedures or queries<\/li>\n\n\n\n<li>create, copy, drop, rename and alter databases, tables, columns and indexes<\/li>\n\n\n\n<li>maintenance server, databases and tables, with proposals on server configuration<\/li>\n\n\n\n<li>load text files into tables<\/li>\n<\/ul><p>You can read more features at <a href=\"https:\/\/docs.phpmyadmin.net\/en\/latest\/intro.html#supported-features\" target=\"_blank\" rel=\"noopener\">official project page<\/a>.<\/p><h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2><p>That&rsquo;s it, now you can log in! You have completed the phpMyAdmin install on CentOS 9 Stream.<\/p><p>After you login you will see the intuitive dashboard, that is most likely familiar to any shared or cloud hosting users.<\/p><p>phpMyAdmin is easy-to-use and acts as an all encompassing solution for many business database needs. You don&rsquo;t need to be an experienced database administrator in order to work with phpMyAdmin, which is the primary reason of its popularity. Happy management, and we&rsquo;ll see you in the next article.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is a database that is popular above all kinds of developers! It&rsquo;s open source and maintains a perfect balance between speed and features. That&rsquo;s why in this tutorial, we&rsquo;ll show you how to install phpMyAdmin on CentOS 9 Stream &ndash; an amazing tool for MySQL database management. Your VPS will have an additional utility [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/ph\/tutorials\/how-to-install-phpmyadmin-on-centos\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":110,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"How to Install phpMyAdmin on CentOS 9","rank_math_description":"How to install phpMyAdmin on CentOS 9: 1. Access your VPS 2. Install an Apache web server and PHP 3. Install the EPEL repository + more.","rank_math_focus_keyword":"install phpmyadmin centos","footnotes":""},"categories":[1],"tags":[],"class_list":["post-16169","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-install-phpmyadmin-on-centos","default":1},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/instalar-phpmyadmin-centos","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/install-phpmyadmin-centos","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-install-phpmyadmin-on-centos","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-install-phpmyadmin-on-centos","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-install-phpmyadmin-on-centos","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/instalar-phpmyadmin-centos","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-install-phpmyadmin-on-centos","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/posts\/16169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/users\/110"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/comments?post=16169"}],"version-history":[{"count":24,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/posts\/16169\/revisions"}],"predecessor-version":[{"id":124625,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/posts\/16169\/revisions\/124625"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/media?parent=16169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/categories?post=16169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/ph\/tutorials\/wp-json\/wp\/v2\/tags?post=16169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}