In web hosting, managing databases effectively is a crucial skill. One of the most popular tools for this task is phpMyAdmin, a free software tool written in PHP designed to handle the administration of MySQL over the World Wide Web.<\/p>\n
This tool can manage an entire MySQL server (requiring a super-user) as well as a single database. It supports a wide range of operations with MySQL, with the most frequently used operations supported by the user interface. This includes managing databases, tables, fields, relations, indexes, users, permissions, and more. Additionally, it provides the ability to directly execute any SQL statement.<\/p>\n
In this tutorial, we will guide you through the steps to install phpMyAdmin on CentOS 6.3 using the EPEL repository. This tutorial is designed for webmasters and website administrators who are familiar with managing servers and want to add phpMyAdmin to their toolkit. Before we begin, it’s important to note that there are some prerequisites for this installation. You should have already configured the EPEL Repository on CentOS 6.3, installed Httpd on CentOS 6.3, and installed and secured MySQL Database Server on CentOS 6.3.<\/p>\n
If you need help with these steps, you can find more information on our website about dedicated servers<\/a>, VPS servers<\/a>, cloud hosting<\/a>, and shared hosting<\/a>.<\/p>\n The first step in setting up phpMyAdmin on CentOS 6.3 is to install the necessary packages. This can be done by running the following command:<\/p>\n This command will install phpMyAdmin, php-mysql, and php-mcrypt using the EPEL repository. The ‘-y’ option is used to automatically answer ‘yes’ to any prompts that may appear during the installation process.<\/p>\n Example:<\/p>\n Once the necessary packages are installed, you will need to configure phpMyAdmin to allow access from your IP address. This can be done by editing the phpMyAdmin configuration file. The following command will open the configuration file in a text editor:<\/p>\n In this file, you will need to add your IP address to the list of allowed IPs. For example, if your IP address is 192.168.1.0\/24, you would add the following lines to the configuration file:<\/p>\n This configuration allows access to phpMyAdmin from the local machine (127.0.0.1) and from the IP range 192.168.1.0\/24.<\/p>\n After making changes to the phpMyAdmin configuration file, you will need to reload or restart the Apache HTTPD service for the changes to take effect. This can be done by running the following command:<\/p>\n This command will reload the Apache HTTPD service, applying the changes made to the phpMyAdmin configuration file.<\/p>\n Setting up phpMyAdmin on CentOS 6.3 using the EPEL repository involves installing the necessary packages, configuring phpMyAdmin to allow access from your IP address, and reloading or restarting the Apache HTTPD service. By following these steps, you can easily manage your MySQL databases through a user-friendly web interface.<\/p>\n Remember, it’s important to secure your phpMyAdmin installation by only allowing access from trusted IP addresses and using strong passwords for your MySQL databases.<\/p>\n For more tutorials on server management and web hosting, visit our blog<\/a> and explore our guides on Apache<\/a>, Nginx<\/a>, and LiteSpeed<\/a> servers.<\/p>\n What is phpMyAdmin?<\/p>\n \n phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. It supports a wide range of operations on MySQL and can manage an entire MySQL server as well as a single database.<\/span>\n <\/p>\n<\/li>\n What is the EPEL repository?<\/p>\n \n The EPEL (Extra Packages for Enterprise Linux) repository is a community-based repository hosted by the Fedora project. It provides high-quality add-on software packages for Linux distributions including CentOS, RHEL, and Scientific Linux.<\/span>\n <\/p>\n<\/li>\n Why do I need to reload or restart the Apache HTTPD service?<\/p>\n \n Reloading or restarting the Apache HTTPD service is necessary to apply any changes made to its configuration files. This ensures that the service is running with the most up-to-date configuration.<\/span>\n <\/p>\n<\/li>\n What does the ‘yum –enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y’ command do?<\/p>\n \n This command installs phpMyAdmin, php-mysql, and php-mcrypt using the EPEL repository. The ‘yum’ command is the package manager for CentOS and other RHEL-based distributions. The ‘–enablerepo=epel’ option tells yum to use the EPEL repository, and the ‘-y’ option automatically answers ‘yes’ to any prompts that may appear during the installation process.<\/span>\n <\/p>\n<\/li>\n How do I allow access to phpMyAdmin from my IP address?<\/p>\n \n You can allow access to phpMyAdmin from your IP address by adding your IP address to the list of allowed IPs in the phpMyAdmin configuration file. This can be done by editing the file ‘\/etc\/httpd\/conf.d\/phpMyAdmin.conf’ and adding your IP address to the ‘Allow from’ line under the ‘Apache 2.2’ section.<\/span>\n <\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":" In web hosting, managing databases effectively is a crucial skill. One of the most popular tools for this task is phpMyAdmin, a free software tool written in PHP designed to…<\/p>\n","protected":false},"author":6,"featured_media":1893,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[2055,1008,1027,2062],"tags":[1254,1536,1585,1658,1768],"class_list":["post-3668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-mysql","category-phpmyadmin-linux","category-yum","tag-centos-6-3","tag-linux","tag-mysql","tag-phpmyadmin","tag-setup-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/3668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=3668"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/3668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/1893"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=3668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=3668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=3668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Step 1: Install phpMyAdmin<\/h2>\n
\r\n[root@centos63 ~]# yum --enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y\r\n<\/pre>\n
\r\n[root@centos63 ~]# yum --enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y\r\nLoaded plugins: fastestmirror, presto\r\nLoading mirror speeds from cached hostfile\r\n * base: mirror.issp.co.th\r\n * epel: mirror.nus.edu.sg\r\n * extras: mirror.issp.co.th\r\n * updates: mirror.issp.co.th\r\nSetting up Install Process\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package php-mcrypt.i686 0:5.3.3-1.el6 will be installed\r\n--> Processing Dependency: php-api = 20090626 for package: php-mcrypt-5.3.3-1.el6.i686\r\n--> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt-5.3.3-1.el6.i686\r\n---> Package php-mysql.i686 0:5.3.3-14.el6_3 will be installed\r\n--> Processing Dependency: php-pdo for package: php-mysql-5.3.3-14.el6_3.i686\r\n---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 will be installed\r\n--> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch\r\n--> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch\r\n--> Processing Dependency: php >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch\r\n--> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.5.1-1.el6.noarch\r\n--> Running transaction check\r\n---> Package libmcrypt.i686 0:2.5.8-9.el6 will be installed\r\n---> Package php.i686 0:5.3.3-14.el6_3 will be installed\r\n--> Processing Dependency: php-cli = 5.3.3-14.el6_3 for package: php-5.3.3-14.el6_3.i686\r\n---> Package php-common.i686 0:5.3.3-14.el6_3 will be installed\r\n---> Package php-gd.i686 0:5.3.3-14.el6_3 will be installed\r\n--> Processing Dependency: libpng12.so.0(PNG12_0) for package: php-gd-5.3.3-14.el6_3.i686\r\n--> Processing Dependency: libpng12.so.0 for package: php-gd-5.3.3-14.el6_3.i686\r\n--> Processing Dependency: libjpeg.so.62 for package: php-gd-5.3.3-14.el6_3.i686\r\n--> Processing Dependency: libfreetype.so.6 for package: php-gd-5.3.3-14.el6_3.i686\r\n--> Processing Dependency: libXpm.so.4 for package: php-gd-5.3.3-14.el6_3.i686\r\n--> Processing Dependency: libX11.so.6 for package: php-gd-5.3.3-14.el6_3.i686\r\n---> Package php-mbstring.i686 0:5.3.3-14.el6_3 will be installed\r\n---> Package php-pdo.i686 0:5.3.3-14.el6_3 will be installed\r\n---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed\r\n--> Running transaction check\r\n---> Package freetype.i686 0:2.3.11-6.el6_2.9 will be installed\r\n---> Package libX11.i686 0:1.3-2.el6 will be installed\r\n--> Processing Dependency: libX11-common = 1.3-2.el6 for package: libX11-1.3-2.el6.i686\r\n--> Processing Dependency: libxcb.so.1 for package: libX11-1.3-2.el6.i686\r\n---> Package libXpm.i686 0:3.5.8-2.el6 will be installed\r\n---> Package libjpeg.i686 0:6b-46.el6 will be installed\r\n---> Package libpng.i686 2:1.2.49-1.el6_2 will be installed\r\n---> Package php-cli.i686 0:5.3.3-14.el6_3 will be installed\r\n--> Running transaction check\r\n---> Package libX11-common.noarch 0:1.3-2.el6 will be installed\r\n---> Package libxcb.i686 0:1.5-1.el6 will be installed\r\n--> Processing Dependency: libXau.so.6 for package: libxcb-1.5-1.el6.i686\r\n--> Running transaction check\r\n---> Package libXau.i686 0:1.0.5-1.el6 will be installed\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n====================================================================================================\r\n Package Arch Version Repository Size\r\n====================================================================================================\r\nInstalling:\r\n php-mcrypt i686 5.3.3-1.el6 epel 18 k\r\n php-mysql i686 5.3.3-14.el6_3 updates 77 k\r\n phpMyAdmin noarch 3.5.1-1.el6 epel 4.2 M\r\nInstalling for dependencies:\r\n freetype i686 2.3.11-6.el6_2.9 CentOS6.3-Repository 363 k\r\n libX11 i686 1.3-2.el6 CentOS6.3-Repository 585 k\r\n libX11-common noarch 1.3-2.el6 CentOS6.3-Repository 188 k\r\n libXau i686 1.0.5-1.el6 CentOS6.3-Repository 22 k\r\n libXpm i686 3.5.8-2.el6 CentOS6.3-Repository 58 k\r\n libjpeg i686 6b-46.el6 CentOS6.3-Repository 133 k\r\n libmcrypt i686 2.5.8-9.el6 epel 94 k\r\n libpng i686 2:1.2.49-1.el6_2 CentOS6.3-Repository 184 k\r\n libxcb i686 1.5-1.el6 CentOS6.3-Repository 104 k\r\n php i686 5.3.3-14.el6_3 updates 1.1 M\r\n php-cli i686 5.3.3-14.el6_3 updates 2.2 M\r\n php-common i686 5.3.3-14.el6_3 updates 523 k\r\n php-gd i686 5.3.3-14.el6_3 updates 103 k\r\n php-mbstring i686 5.3.3-14.el6_3 updates 453 k\r\n php-pdo i686 5.3.3-14.el6_3 updates 72 k\r\n php-php-gettext noarch 1.0.11-3.el6 epel 21 k\r\n\r\nTransaction Summary\r\n====================================================================================================\r\nInstall 19 Package(s)\r\n\r\nTotal download size: 10 M\r\nInstalled size: 38 M\r\nDownloading Packages:\r\nSetting up and reading Presto delta metadata\r\nupdates\/prestodelta | 72 kB 00:00\r\nProcessing delta metadata\r\nPackage(s) data still to download: 10 M\r\n(1\/19): libmcrypt-2.5.8-9.el6.i686.rpm | 94 kB 00:00\r\n(2\/19): php-5.3.3-14.el6_3.i686.rpm | 1.1 MB 00:09\r\n(3\/19): php-cli-5.3.3-14.el6_3.i686.rpm | 2.2 MB 00:19\r\n(4\/19): php-common-5.3.3-14.el6_3.i686.rpm | 523 kB 00:04\r\n(5\/19): php-gd-5.3.3-14.el6_3.i686.rpm | 103 kB 00:00\r\n(6\/19): php-mbstring-5.3.3-14.el6_3.i686.rpm | 453 kB 00:04\r\n(7\/19): php-mcrypt-5.3.3-1.el6.i686.rpm | 18 kB 00:00\r\n(8\/19): php-mysql-5.3.3-14.el6_3.i686.rpm | 77 kB 00:00\r\n(9\/19): php-pdo-5.3.3-14.el6_3.i686.rpm | 72 kB 00:00\r\n(10\/19): php-php-gettext-1.0.11-3.el6.noarch.rpm | 21 kB 00:00\r\n(11\/19): phpMyAdmin-3.5.1-1.el6.noarch.rpm | 4.2 MB 00:36\r\n----------------------------------------------------------------------------------------------------\r\nTotal 135 kB\/s | 10 MB 01:19\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\n Installing : php-common-5.3.3-14.el6_3.i686 1\/19\r\n Installing : libX11-common-1.3-2.el6.noarch 2\/19\r\n Installing : php-mbstring-5.3.3-14.el6_3.i686 3\/19\r\n Installing : php-php-gettext-1.0.11-3.el6.noarch 4\/19\r\n Installing : php-cli-5.3.3-14.el6_3.i686 5\/19\r\n Installing : php-5.3.3-14.el6_3.i686 6\/19\r\n Installing : php-pdo-5.3.3-14.el6_3.i686 7\/19\r\n Installing : php-mysql-5.3.3-14.el6_3.i686 8\/19\r\n Installing : libmcrypt-2.5.8-9.el6.i686 9\/19\r\n Installing : php-mcrypt-5.3.3-1.el6.i686 10\/19\r\n Installing : libjpeg-6b-46.el6.i686 11\/19\r\n Installing : 2:libpng-1.2.49-1.el6_2.i686 12\/19\r\n Installing : libXau-1.0.5-1.el6.i686 13\/19\r\n Installing : libxcb-1.5-1.el6.i686 14\/19\r\n Installing : libX11-1.3-2.el6.i686 15\/19\r\n Installing : libXpm-3.5.8-2.el6.i686 16\/19\r\n Installing : freetype-2.3.11-6.el6_2.9.i686 17\/19\r\n Installing : php-gd-5.3.3-14.el6_3.i686 18\/19\r\n Installing : phpMyAdmin-3.5.1-1.el6.noarch 19\/19\r\n Verifying : freetype-2.3.11-6.el6_2.9.i686 1\/19\r\n Verifying : php-5.3.3-14.el6_3.i686 2\/19\r\n Verifying : php-cli-5.3.3-14.el6_3.i686 3\/19\r\n Verifying : libXau-1.0.5-1.el6.i686 4\/19\r\n Verifying : php-common-5.3.3-14.el6_3.i686 5\/19\r\n Verifying : php-mbstring-5.3.3-14.el6_3.i686 6\/19\r\n Verifying : libXpm-3.5.8-2.el6.i686 7\/19\r\n Verifying : 2:libpng-1.2.49-1.el6_2.i686 8\/19\r\n Verifying : libxcb-1.5-1.el6.i686 9\/19\r\n Verifying : phpMyAdmin-3.5.1-1.el6.noarch 10\/19\r\n Verifying : libX11-1.3-2.el6.i686 11\/19\r\n Verifying : php-php-gettext-1.0.11-3.el6.noarch 12\/19\r\n Verifying : php-gd-5.3.3-14.el6_3.i686 13\/19\r\n Verifying : libjpeg-6b-46.el6.i686 14\/19\r\n Verifying : libX11-common-1.3-2.el6.noarch 15\/19\r\n Verifying : php-mysql-5.3.3-14.el6_3.i686 16\/19\r\n Verifying : php-pdo-5.3.3-14.el6_3.i686 17\/19\r\n Verifying : php-mcrypt-5.3.3-1.el6.i686 18\/19\r\n Verifying : libmcrypt-2.5.8-9.el6.i686 19\/19\r\n\r\nInstalled:\r\n php-mcrypt.i686 0:5.3.3-1.el6 php-mysql.i686 0:5.3.3-14.el6_3 phpMyAdmin.noarch 0:3.5.1-1.el6\r\n\r\nDependency Installed:\r\n freetype.i686 0:2.3.11-6.el6_2.9 libX11.i686 0:1.3-2.el6\r\n libX11-common.noarch 0:1.3-2.el6 libXau.i686 0:1.0.5-1.el6\r\n libXpm.i686 0:3.5.8-2.el6 libjpeg.i686 0:6b-46.el6\r\n libmcrypt.i686 0:2.5.8-9.el6 libpng.i686 2:1.2.49-1.el6_2\r\n libxcb.i686 0:1.5-1.el6 php.i686 0:5.3.3-14.el6_3\r\n php-cli.i686 0:5.3.3-14.el6_3 php-common.i686 0:5.3.3-14.el6_3\r\n php-gd.i686 0:5.3.3-14.el6_3 php-mbstring.i686 0:5.3.3-14.el6_3\r\n php-pdo.i686 0:5.3.3-14.el6_3 php-php-gettext.noarch 0:1.0.11-3.el6\r\n\r\nComplete!\r\n<\/pre>\n
Step 2: Configure phpMyAdmin<\/h2>\n
\r\n[root@centos63 ~]# vi \/etc\/httpd\/conf.d\/phpMyAdmin.conf\r\n<\/pre>\n
\r\n<Directory \/usr\/share\/phpMyAdmin\/>\r\n <IfModule mod_authz_core.c>\r\n # Apache 2.4\r\n <RequireAny>\r\n Require ip 127.0.0.1\r\n Require ip ::1\r\n <\/RequireAny>\r\n <\/IfModule>\r\n <IfModule !mod_authz_core.c>\r\n # Apache 2.2\r\n Order Deny,Allow\r\n Deny from All\r\n Allow from 127.0.0.1 192.168.1.0\/24\r\n Allow from ::1\r\n <\/IfModule>\r\n<\/Directory>\r\n<\/pre>\n
Step 3: Reload or Restart Apache HTTPD<\/h2>\n
\r\n[root@centos63 ~]# \/etc\/rc.d\/init.d\/httpd reload\r\n<\/pre>\n
Commands Mentioned<\/h2>\n
\n
Conclusion<\/h2>\n
FAQ<\/h2>\n
\n