This will guide will show you what you need to do to install phpmyadmin on CentOS via command line. In order to install phpMyAdmin you need to add a repository that contains the download. You can add the repository by executing the following command.

rpm -ivh http://ftp.jaist.ac.jp/pub/Linux/Fedora/epel/6/i386/epel-release-6-8.noarch.rpm

Once the repository has been added you will need to update the sources.

yum check-update

Now that the repository has been added you can install phpMyAdmin

yum install phpMyAdmin

Once installed restart the server in order to pick up the application.

service httpd restart

Now you can now use PhpMyAdmin through your web browser by visiting /phpmyadmin

If You Get Error 403 Forbidden

Sometimes you might get a 403 forbidden error. This is because phpmyadmin is denying access from outside the local domain. If you are accessing a remote server via SSH you will most likely have this issue. To resolve it you will need to either remove the IP restriction or simply remove all restrictions. This is done by editing the phpmyadmin conf file.

vi /etc/httpd/conf.d/phpMyAdmin.conf

You will see a few blocks of code that look like the code below. You will need to either remove these (not recommended) or replace 127.0.0.1 with your own IP address. You can get the IP address of your address by typing “whats my ip” into google.

<IfModule mod_authz_core.c>
    # Apache 2.4
    <RequireAny>
        Require ip 127.0.0.1
        Require ip ::1
    </RequireAny>
</IfModule>