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.
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.
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.
If you need help with these steps, you can find more information on our website about dedicated servers, VPS servers, cloud hosting, and shared hosting.
Step 1: Install phpMyAdmin
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:
[root@centos63 ~]# yum --enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y
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.
Example:
[root@centos63 ~]# yum --enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y Loaded plugins: fastestmirror, presto Loading mirror speeds from cached hostfile * base: mirror.issp.co.th * epel: mirror.nus.edu.sg * extras: mirror.issp.co.th * updates: mirror.issp.co.th Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mcrypt.i686 0:5.3.3-1.el6 will be installed --> Processing Dependency: php-api = 20090626 for package: php-mcrypt-5.3.3-1.el6.i686 --> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt-5.3.3-1.el6.i686 ---> Package php-mysql.i686 0:5.3.3-14.el6_3 will be installed --> Processing Dependency: php-pdo for package: php-mysql-5.3.3-14.el6_3.i686 ---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 will be installed --> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch --> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch --> Processing Dependency: php >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch --> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.5.1-1.el6.noarch --> Running transaction check ---> Package libmcrypt.i686 0:2.5.8-9.el6 will be installed ---> Package php.i686 0:5.3.3-14.el6_3 will be installed --> Processing Dependency: php-cli = 5.3.3-14.el6_3 for package: php-5.3.3-14.el6_3.i686 ---> Package php-common.i686 0:5.3.3-14.el6_3 will be installed ---> Package php-gd.i686 0:5.3.3-14.el6_3 will be installed --> Processing Dependency: libpng12.so.0(PNG12_0) for package: php-gd-5.3.3-14.el6_3.i686 --> Processing Dependency: libpng12.so.0 for package: php-gd-5.3.3-14.el6_3.i686 --> Processing Dependency: libjpeg.so.62 for package: php-gd-5.3.3-14.el6_3.i686 --> Processing Dependency: libfreetype.so.6 for package: php-gd-5.3.3-14.el6_3.i686 --> Processing Dependency: libXpm.so.4 for package: php-gd-5.3.3-14.el6_3.i686 --> Processing Dependency: libX11.so.6 for package: php-gd-5.3.3-14.el6_3.i686 ---> Package php-mbstring.i686 0:5.3.3-14.el6_3 will be installed ---> Package php-pdo.i686 0:5.3.3-14.el6_3 will be installed ---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed --> Running transaction check ---> Package freetype.i686 0:2.3.11-6.el6_2.9 will be installed ---> Package libX11.i686 0:1.3-2.el6 will be installed --> Processing Dependency: libX11-common = 1.3-2.el6 for package: libX11-1.3-2.el6.i686 --> Processing Dependency: libxcb.so.1 for package: libX11-1.3-2.el6.i686 ---> Package libXpm.i686 0:3.5.8-2.el6 will be installed ---> Package libjpeg.i686 0:6b-46.el6 will be installed ---> Package libpng.i686 2:1.2.49-1.el6_2 will be installed ---> Package php-cli.i686 0:5.3.3-14.el6_3 will be installed --> Running transaction check ---> Package libX11-common.noarch 0:1.3-2.el6 will be installed ---> Package libxcb.i686 0:1.5-1.el6 will be installed --> Processing Dependency: libXau.so.6 for package: libxcb-1.5-1.el6.i686 --> Running transaction check ---> Package libXau.i686 0:1.0.5-1.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================== Package Arch Version Repository Size ==================================================================================================== Installing: php-mcrypt i686 5.3.3-1.el6 epel 18 k php-mysql i686 5.3.3-14.el6_3 updates 77 k phpMyAdmin noarch 3.5.1-1.el6 epel 4.2 M Installing for dependencies: freetype i686 2.3.11-6.el6_2.9 CentOS6.3-Repository 363 k libX11 i686 1.3-2.el6 CentOS6.3-Repository 585 k libX11-common noarch 1.3-2.el6 CentOS6.3-Repository 188 k libXau i686 1.0.5-1.el6 CentOS6.3-Repository 22 k libXpm i686 3.5.8-2.el6 CentOS6.3-Repository 58 k libjpeg i686 6b-46.el6 CentOS6.3-Repository 133 k libmcrypt i686 2.5.8-9.el6 epel 94 k libpng i686 2:1.2.49-1.el6_2 CentOS6.3-Repository 184 k libxcb i686 1.5-1.el6 CentOS6.3-Repository 104 k php i686 5.3.3-14.el6_3 updates 1.1 M php-cli i686 5.3.3-14.el6_3 updates 2.2 M php-common i686 5.3.3-14.el6_3 updates 523 k php-gd i686 5.3.3-14.el6_3 updates 103 k php-mbstring i686 5.3.3-14.el6_3 updates 453 k php-pdo i686 5.3.3-14.el6_3 updates 72 k php-php-gettext noarch 1.0.11-3.el6 epel 21 k Transaction Summary ==================================================================================================== Install 19 Package(s) Total download size: 10 M Installed size: 38 M Downloading Packages: Setting up and reading Presto delta metadata updates/prestodelta | 72 kB 00:00 Processing delta metadata Package(s) data still to download: 10 M (1/19): libmcrypt-2.5.8-9.el6.i686.rpm | 94 kB 00:00 (2/19): php-5.3.3-14.el6_3.i686.rpm | 1.1 MB 00:09 (3/19): php-cli-5.3.3-14.el6_3.i686.rpm | 2.2 MB 00:19 (4/19): php-common-5.3.3-14.el6_3.i686.rpm | 523 kB 00:04 (5/19): php-gd-5.3.3-14.el6_3.i686.rpm | 103 kB 00:00 (6/19): php-mbstring-5.3.3-14.el6_3.i686.rpm | 453 kB 00:04 (7/19): php-mcrypt-5.3.3-1.el6.i686.rpm | 18 kB 00:00 (8/19): php-mysql-5.3.3-14.el6_3.i686.rpm | 77 kB 00:00 (9/19): php-pdo-5.3.3-14.el6_3.i686.rpm | 72 kB 00:00 (10/19): php-php-gettext-1.0.11-3.el6.noarch.rpm | 21 kB 00:00 (11/19): phpMyAdmin-3.5.1-1.el6.noarch.rpm | 4.2 MB 00:36 ---------------------------------------------------------------------------------------------------- Total 135 kB/s | 10 MB 01:19 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : php-common-5.3.3-14.el6_3.i686 1/19 Installing : libX11-common-1.3-2.el6.noarch 2/19 Installing : php-mbstring-5.3.3-14.el6_3.i686 3/19 Installing : php-php-gettext-1.0.11-3.el6.noarch 4/19 Installing : php-cli-5.3.3-14.el6_3.i686 5/19 Installing : php-5.3.3-14.el6_3.i686 6/19 Installing : php-pdo-5.3.3-14.el6_3.i686 7/19 Installing : php-mysql-5.3.3-14.el6_3.i686 8/19 Installing : libmcrypt-2.5.8-9.el6.i686 9/19 Installing : php-mcrypt-5.3.3-1.el6.i686 10/19 Installing : libjpeg-6b-46.el6.i686 11/19 Installing : 2:libpng-1.2.49-1.el6_2.i686 12/19 Installing : libXau-1.0.5-1.el6.i686 13/19 Installing : libxcb-1.5-1.el6.i686 14/19 Installing : libX11-1.3-2.el6.i686 15/19 Installing : libXpm-3.5.8-2.el6.i686 16/19 Installing : freetype-2.3.11-6.el6_2.9.i686 17/19 Installing : php-gd-5.3.3-14.el6_3.i686 18/19 Installing : phpMyAdmin-3.5.1-1.el6.noarch 19/19 Verifying : freetype-2.3.11-6.el6_2.9.i686 1/19 Verifying : php-5.3.3-14.el6_3.i686 2/19 Verifying : php-cli-5.3.3-14.el6_3.i686 3/19 Verifying : libXau-1.0.5-1.el6.i686 4/19 Verifying : php-common-5.3.3-14.el6_3.i686 5/19 Verifying : php-mbstring-5.3.3-14.el6_3.i686 6/19 Verifying : libXpm-3.5.8-2.el6.i686 7/19 Verifying : 2:libpng-1.2.49-1.el6_2.i686 8/19 Verifying : libxcb-1.5-1.el6.i686 9/19 Verifying : phpMyAdmin-3.5.1-1.el6.noarch 10/19 Verifying : libX11-1.3-2.el6.i686 11/19 Verifying : php-php-gettext-1.0.11-3.el6.noarch 12/19 Verifying : php-gd-5.3.3-14.el6_3.i686 13/19 Verifying : libjpeg-6b-46.el6.i686 14/19 Verifying : libX11-common-1.3-2.el6.noarch 15/19 Verifying : php-mysql-5.3.3-14.el6_3.i686 16/19 Verifying : php-pdo-5.3.3-14.el6_3.i686 17/19 Verifying : php-mcrypt-5.3.3-1.el6.i686 18/19 Verifying : libmcrypt-2.5.8-9.el6.i686 19/19 Installed: 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 Dependency Installed: freetype.i686 0:2.3.11-6.el6_2.9 libX11.i686 0:1.3-2.el6 libX11-common.noarch 0:1.3-2.el6 libXau.i686 0:1.0.5-1.el6 libXpm.i686 0:3.5.8-2.el6 libjpeg.i686 0:6b-46.el6 libmcrypt.i686 0:2.5.8-9.el6 libpng.i686 2:1.2.49-1.el6_2 libxcb.i686 0:1.5-1.el6 php.i686 0:5.3.3-14.el6_3 php-cli.i686 0:5.3.3-14.el6_3 php-common.i686 0:5.3.3-14.el6_3 php-gd.i686 0:5.3.3-14.el6_3 php-mbstring.i686 0:5.3.3-14.el6_3 php-pdo.i686 0:5.3.3-14.el6_3 php-php-gettext.noarch 0:1.0.11-3.el6 Complete!
Step 2: Configure phpMyAdmin
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:
[root@centos63 ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf
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:
<Directory /usr/share/phpMyAdmin/> <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require ip 127.0.0.1 Require ip ::1 </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 192.168.1.0/24 Allow from ::1 </IfModule> </Directory>
This configuration allows access to phpMyAdmin from the local machine (127.0.0.1) and from the IP range 192.168.1.0/24.
Step 3: Reload or Restart Apache HTTPD
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:
[root@centos63 ~]# /etc/rc.d/init.d/httpd reload
This command will reload the Apache HTTPD service, applying the changes made to the phpMyAdmin configuration file.
Commands Mentioned
- yum –enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y – This command installs phpMyAdmin, php-mysql, and php-mcrypt using the EPEL repository.
- vi /etc/httpd/conf.d/phpMyAdmin.conf – This command opens the phpMyAdmin configuration file in a text editor.
- /etc/rc.d/init.d/httpd reload – This command reloads the Apache HTTPD service, applying any changes made to the configuration files.
Conclusion
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.
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.
For more tutorials on server management and web hosting, visit our blog and explore our guides on Apache, Nginx, and LiteSpeed servers.
FAQ
-
What is phpMyAdmin?
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.
-
What is the EPEL repository?
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.
-
Why do I need to reload or restart the Apache HTTPD service?
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.
-
What does the ‘yum –enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y’ command do?
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.
-
How do I allow access to phpMyAdmin from my IP address?
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.
1 Comment
A huge thanks for the guides you post, they are incredibly useful and very thorough. Really appreciate the time and effort that goes into this site.