Install phpMyAdmin 4.2.1 on Fedora 20/19, CentOS/RHEL 6.5/5.10

phpMyAdmin-logoThis is guide, howto install phpMyAdmin 4.2.1 with Nginx or Apache on Fedora 20/19/18/17/16, CentOS 6.5/6.4/6.3/6.2/6.1/6/5.10 and Red Hat (RHEL) 6.5/6.4/6.3/6.2/6.1/6/5.10 servers. phpMyAdmin needs web server with PHP and MySQL database. This guide uses Apache web server with PHP 5.5 or Nginx web server with PHP 5.5 (PHP-FPM) and Mysql 5.5 database server. You can also use your already installed versions of web server, PHP and MySQL.

If you want to install phpMyAdmin with Apache then use a – [Apache] sections and if you want install phpMyAdmin with Nginx then use b – [Nginx] sections.

1. Install Needed Web and Database Servers

[Apache]

1.1a Install the whole LAMP environment with following guide

LAMP (Linux/Apache/MySQL/PHP) on Fedora, CentOS/Red Hat (RHEL)

[Nginx]

1.1b Install the whole LEMP environment with following guide

LEMP (Linux/Nginx/MySQL/PHP) on Fedora, CentOS/Red Hat (RHEL)

OR

[Apache]

1.2a Install just MySQL and Apache with PHP using following guides

  1. Install MySQL 5.5 on Fedora, CentOS, Red Hat (RHEL)
  2. Install Apache (httpd) and PHP 5.5 on Fedora, CentOS, Red Hat (RHEL)

[Nginx]

1.2b Install just MySQL and Nginx with PHP (PHP-FPM) using following guides

  1. Install MySQL 5.5 on Fedora, CentOS, Red Hat (RHEL)
  2. Install Nginx and PHP 5.5 (PHP-FPM) on Fedora, CentOS, Red Hat (RHEL)

2. Install phpMyAdmin 4.2.1 on Fedora 20/19/18/17/16, CentOS/Red Hat (RHEL) 6.5/6.4/6.3/6.2/6.1/6/5.10

2.1 Change root user

su -
## OR ##
sudo -i

2.2 Install Remi repository

Fedora

## Remi Dependency on Fedora
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
 
 
## Fedora 20 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-20.rpm
 
## Fedora 19 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm
 
## Fedora 18 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
 
## Fedora 17 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
 
## Fedora 16 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm

CentOS and Red Hat (RHEL)

## Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
 
## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
 
 
## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ##
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
 
## CentOS 5 and Red Hat (RHEL) 5 ## 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Note: You can also use original Fedora phpMyAdmin builds or EPEL packages.

2.3 Install phpMyAdmin

yum --enablerepo=remi install phpmyadmin

If you have PHP 5.5 on CentOS/Red Hat (RHEL) then install phpMyAdmin with following command:

yum --enablerepo=remi,remi-php55 install phpmyadmin

3. Setup phpMyAdmin with Apache or Nginx

[Apache]

3.1a Check phpMyAdmin Apache Virtual Host

When you install phpMyAdmin you got working Apache Virtual Host automatically, but if you want change it, then check /etc/httpd/conf.d/phpMyAdmin.conf file and modify it.

[Nginx]

3.1b Create phpMyAdmin Nginx Virtual Host and Other Setups

Create /etc/nginx/sites-available/phpMyAdmin file with following content:

server {
       listen   80;
       server_name pma;
       access_log /var/log/nginx/phpmyadmin/access.log;
       error_log /var/log/nginx/phpmyadmin/error.log;
       root /usr/share/phpMyAdmin;
 
       location / {
           index  index.php;
       }
 
       ## Images and static content is treated different
       location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
           access_log        off;
           expires           360d;
       }
 
       location ~ /\.ht {
           deny  all;
       }
 
       location ~ /(libraries|setup/frames|setup/libs) {
           deny all;
           return 404;
       }
 
       location ~ \.php$ {
           include /etc/nginx/fastcgi_params;
           fastcgi_pass 127.0.0.1:9000;
           fastcgi_index index.php;
           fastcgi_param SCRIPT_FILENAME $root$fastcgi_script_name;
       }
}

This is Nginx phpMyAdmin virtual host configuration which works pretty much like original phpMyAdmin Apache configuration. I use here server_name pma you could freely change this real host name or some other.

Set pma pointing to localhost, add following to /etc/hosts file:

127.0.0.1  pma

Create needed directory and enable Nginx virtual host:

mkdir -p /var/log/nginx/phpmyadmin
 
cd /etc/nginx/sites-enabled
ln -s /etc/nginx/sites-available/phpMyAdmin

[Apache]

3.2a Restart Apache Web Server

/etc/init.d/httpd restart

[Nginx]

3.2b Restart Nginx Web Server

/etc/init.d/nginx restart

4. Use phpMyAdmin

[Apache]

4.1a Open phpMyAdmin with Apache Setup

Open browser and Goto following address http://localhost/phpmyadmin.

[Nginx]

4.1b Open phpMyAdmin with Nginx Setup

Open browser and Goto following address http://pma/.

4.2 phpMyAdmin Login Screen

Login with your MySQL username and password.
phpMyAdmin Login

[Apache]

4.3a phpMyAdmin 3.4.10 Running on CentOS 6.2 with Apache

phpMyAdmin 3.4.10.1 Apache CentOS 6.2

[Nginx]

4.3b phpMyAdmin 3.4.10 Running on CentOS 6.2 with Nginx

phpMyAdmin 3.4.10.1 Nginx CentOS 6.2

Follow If Not True Then False Updates!

113 Comments

  1. I did all the instructions completely..even edited php.ini file in (/etc/php.ini)..but I see frequently html error 500

    • Hi Alireza,

      Do you use Nginx or Apache?
      Do you get error 500 all the time or does phpMyAdmin work occasionally?

  2. Hey JR,

    I received a 403 error when attempting to connect to phpmyadmin.

    • Hi Kevin and nice to see you here,

      Could you please tell more about your setup:
      – OS
      – Web server
      – Configs what you have
      – Do you try to use it locally or remote

  3. Hey JR,

    I have CentOS 6.2 with Apache and MySql. I use Webmin as my control panel. I set up everything according to you tutorials for WordPress. MySql is working fine, I just know that phpMyAdmin simplifies the process so I wanted to add it. I usually do everything through Webmin, using SSH when I have to. Also, there are other sites on the server running on different IP.

    • Hi again Kevin,

      Thank you for this information.

      Open /etc/httpd/conf.d/phpMyAdmin.conf file and check following:

      <Directory /usr/share/phpMyAdmin/>
         order deny,allow
         deny from all
         allow from 127.0.0.1
         allow from ::1
      </Directory>

      Add your external ips here.

      OR

      change it to:

      <Directory /usr/share/phpMyAdmin/>
         order deny,allow
         allow from all
      </Directory>

      Then restart your web server and try again.

      Please let me know do you get it working?

      • after that service httpd restart

  4. Hey JR,

    Thanks a lot! That worked like a charm.

    • You are very welcome! Nice to hear that it worked. :)

  5. Hi, JR..
    The phpmyadmin in nginx..
    Can I set it to http://localhost/phpmyadmin rather than http://pma/ ?

    Please advice. :)

    • Hi woody,

      You can try following config on your /etc/nginx/conf.d/default.conf:

      location /phpMyAdmin {
        root /usr/share/;
        index index.php index.html index.htm;
        location ~ ^/phpMyAdmin/(.+\.php)$ {
          try_files $uri =404;
          root /usr/share/;
          fastcgi_pass 127.0.0.1:9000;
          fastcgi_index index.php;
          fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
          include /etc/nginx/fastcgi_params;
        }
        location ~* ^/phpMyAdmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
          root /usr/share/;
        }
      }
       
      location /phpmyadmin {
        rewrite ^/* /phpMyAdmin last;
      }

      Restart nginx and then http://localhost/phpmyadmin should work… :)

  6. Hi ,

    I have just installed CentOS 5.8 Final release.
    Completely new to linux i am trying to install a LAMP , Encounter this error

    Can someone tell me what is this and how to solve it ? thanks…

    [root@localhost /]# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    Retrieving http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
    error: skipping http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm – transfer failed – Unknown or unexpected error
    [root@localhost /]#

    • Hi marker,

      Do you have network connection working normally? Could you just try again?

  7. Hello. Thanks for you articles, it’s very usefull for me.

    But I have trouble with phpmyadmin. After install on this manual i have phpMyAdmin – 2.11.11.3. What’s wrong, I don’t know

  8. yum –enablerepo=remi install phpmyadmin
    =============
    –> Running transaction check
    —> Package phpmyadmin.noarch 0:2.11.11.3-2.el6.rf will be installed
    –> Finished Dependency Resolution

    • I found reason: other repository. I fixed it and trying

      yum --enablerepo=remi install phpmyadmin

      and receive:

      Error: Package: php-mcrypt-5.3.15-1.el6.remi.x86_64 (remi)
      Requires: php-common(x86-64) = 5.3.15-1.el6.remi
      Installed: php-common-5.4.5-1.el6.remi.x86_64 (@remi-test)
      php-common(x86-64) = 5.4.5-1.el6.remi
      Available: php-common-5.3.3-3.el6_2.8.x86_64 (base)
      php-common(x86-64) = 5.3.3-3.el6_2.8
      Available: php-common-5.3.3-14.el6_3.x86_64 (updates)
      php-common(x86-64) = 5.3.3-14.el6_3
      Available: php-common-5.3.14-1.el6.remi.x86_64 (remi)
      php-common(x86-64) = 5.3.14-1.el6.remi
      Available: php-common-5.3.15-1.el6.remi.x86_64 (remi)
      php-common(x86-64) = 5.3.15-1.el6.remi
      You could try using --skip-broken to work around the problem
      You could try running: rpm -Va --nofiles --nodigest

      • Hi indapublic,

        Could you post output of following commands:

        yum list \*php\*
         
        yum --enablerepo=remi repolist
        • Thanks for reply.

          [indapublic@myserver ~]$ yum list \*php\*
          Loaded plugins: fastestmirror
          Determining fastest mirrors
          epel/metalink | 13 kB 00:00
          * Webmin: download.webmin.com
          * base: mirror.yandex.ru
          * epel: mirror.yandex.ru
          * extras: mirror.yandex.ru
          * updates: mirror.yandex.ru
          Webmin | 951 B 00:00
          Webmin/primary | 15 kB 00:00
          Webmin 118/118
          base | 3.7 kB 00:00
          base/primary_db | 4.5 MB 00:01
          epel | 4.0 kB 00:00
          epel/primary_db | 4.6 MB 00:02
          extras | 3.0 kB 00:00
          extras/primary_db | 6.3 kB 00:00
          updates | 3.5 kB 00:00
          updates/primary_db | 1.2 MB 00:00
          Installed Packages
          php.x86_64 5.4.5-1.el6.remi @remi-test
          php-cli.x86_64 5.4.5-1.el6.remi @remi-test
          php-common.x86_64 5.4.5-1.el6.remi @remi-test
          php-gd.x86_64 5.4.5-1.el6.remi @remi-test
          php-mbstring.x86_64 5.4.5-1.el6.remi @remi-test
          php-mysql.x86_64 5.4.5-1.el6.remi @remi-test
          php-pdo.x86_64 5.4.5-1.el6.remi @remi-test
          php-xml.x86_64 5.4.5-1.el6.remi @remi-test
          Available Packages
          cups-php.x86_64 1:1.4.2-48.el6 base
          eclipse-phpeclipse.noarch 1.2.1-6.el6 epel
          graphviz-php.x86_64 2.26.0-7.el6 base
          nntpgrab-php.x86_64 0.7.2-1.el6 epel
          php-IDNA_Convert.noarch 0.7.0-1.el6 epel
          php-Kohana.noarch 2.4-1.rc2.el6 epel
          php-PHPMailer.noarch 5.2.1-2.el6 epel
          php-Smarty.noarch 2.6.26-1.el6 epel
          php-ZendFramework.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Auth-Adapter-Ldap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Cache-Backend-Apc.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Cache-Backend-Memcached.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Captcha.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Db-Adapter-Firebird.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Db-Adapter-Mysqli.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Dojo.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Feed.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Gdata.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Ldap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Pdf.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Search-Lucene.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Services.noarch 1.11.12-1.el6 epel
          php-ZendFramework-Soap.noarch 1.11.12-1.el6 epel
          php-ZendFramework-demos.noarch 1.11.12-1.el6 epel
          php-ZendFramework-extras.noarch 1.11.12-1.el6 epel
          php-adodb.noarch 4.95-1.a.el6 epel
          php-bartlett-PHP-CompatInfo.noarch 2.5.0-1.el6.1 epel
          php-bartlett-PHP-Reflect.noarch 1.3.0-1.el6 epel
          php-bcmath.x86_64 5.3.3-14.el6_3 updates
          php-channel-bartlett.noarch 1.3-1.el6 epel
          php-channel-deepend.noarch 1.3-2.el6 epel
          php-channel-digitalsandwich.noarch 1.3-2.el6 epel
          php-channel-doctrine.noarch 1.3-1.el6.1 epel
          php-channel-ezc.noarch 1-2.el6 epel
          php-channel-horde.noarch 1.0-1.el6 epel
          php-channel-htmlpurifier.noarch 1.0-2.el6 epel
          php-channel-pdepend.noarch 1.3-4.el6 epel
          php-channel-pearplex.noarch 1.3-2.el6 epel
          php-channel-phing.noarch 1.3-1.el6 epel
          php-channel-phpdoc.noarch 1.3-3.el6 epel
          php-channel-phpmd.noarch 1.3-3.el6 epel
          php-channel-phpqatools.noarch 1.3-3.el6 epel
          php-channel-phpunit.noarch 1.3-3.el6 epel
          php-channel-swift.noarch 1.3-2.el6 epel
          php-channel-symfony.noarch 1.3-1.el6 epel
          php-channel-symfony2.noarch 1.0-3.el6 epel
          php-channel-twig.noarch 1.0-3.el6 epel
          php-dba.x86_64 5.3.3-14.el6_3 updates
          php-deepend-Mockery.noarch 0.7.2-1.el6 epel
          php-devel.x86_64 5.3.3-14.el6_3 updates
          php-digitalsandwich-Phake.noarch 1.0.2-1.el6 epel
          php-doctrine-Doctrine.noarch 1.2.4-1.el6 epel
          php-domxml-php4-php5.noarch 1.21.2-1.el6 epel
          php-eaccelerator.x86_64 1:0.9.6.1-1.el6 epel
          php-email-address-validation.noarch 0-0.3.20090910svn.el6 epel
          php-embedded.x86_64 5.3.3-14.el6_3 updates
          php-enchant.x86_64 5.3.3-14.el6_3 updates
          php-ezc-Archive.noarch 1.4.1-2.el6 epel
          php-ezc-Authentication.noarch 1.3.1-1.el6 epel
          php-ezc-AuthenticationDatabaseTiein.noarch 1.1-1.el6 epel
          php-ezc-Base.noarch 1.8-1.el6 epel
          php-ezc-Cache.noarch 1.5-1.el6 epel
          php-ezc-Configuration.noarch 1.3.5-1.el6 epel
          php-ezc-ConsoleTools.noarch 1.6.1-1.el6 epel
          php-ezc-Database.noarch 1.4.7-1.el6 epel
          php-ezc-DatabaseSchema.noarch 1.4.4-1.el6 epel
          php-ezc-EventLog.noarch 1.4-2.el6 epel
          php-ezc-EventLogDatabaseTiein.noarch 1.0.2-1.el6 epel
          php-ezc-Feed.noarch 1.3-1.el6 epel
          php-ezc-File.noarch 1.2-3.el6 epel
          php-ezc-Graph.noarch 1.5-1.el6 epel
          php-ezc-Mail.noarch 1.7.1-1.el6 epel
          php-ezc-PersistentObject.noarch 1.7.1-1.el6 epel
          php-ezc-PersistentObjectDatabaseSchemaTiein.noarch 1.3-1.el6 epel
          php-ezc-SystemInformation.noarch 1.0.8-1.el6 epel
          php-ezc-Template.noarch 1.4.2-1.el6 epel
          php-ezc-Webdav.noarch 1.1.4-1.el6 epel
          php-facedetect.x86_64 1.0.0-6.el6 epel
          php-feedcreator.noarch 1.7.2-4.el6 epel
          php-fpdf.noarch 1.6-4.el6 epel
          php-fpdf-doc.noarch 1.6-4.el6 epel
          php-geshi.noarch 1.0.8.8-1.el6 epel
          php-htmLawed.noarch 1.1.12-1.el6 epel
          php-idn.x86_64 1.2c-1.el6 epel
          php-imap.x86_64 5.3.3-14.el6_3 updates
          php-interbase.x86_64 5.3.3-1.el6 epel
          php-intl.x86_64 5.3.3-14.el6_3 updates
          php-layers-menu.noarch 3.2.0-0.2.rc.el6 epel
          php-ldap.x86_64 5.3.3-14.el6_3 updates
          php-libdmtx.x86_64 0.7.2-3.el6 epel
          php-libpuzzle.x86_64 0.11-7.el6 epel
          php-magickwand.x86_64 1.0.9-1.el6 epel
          php-magpierss.noarch 0.72-6.el6 epel
          php-mapi.x86_64 7.0.8-1.el6 epel
          php-mcrypt.x86_64 5.3.3-1.el6 epel
          php-mssql.x86_64 5.3.3-1.el6 epel
          php-odbc.x86_64 5.3.3-14.el6_3 updates
          php-pdepend-PHP-Depend.noarch 1.0.7-1.el6 epel
          php-pear.noarch 1:1.9.4-4.el6 base
          php-pear-Auth-RADIUS.noarch 1.0.7-1.el6 epel
          php-pear-Auth-SASL.noarch 1.0.4-1.el6 epel
          php-pear-Benchmark.noarch 1.2.7-4.el6 epel
          php-pear-CAS.noarch 1.3.0-2.el6 epel
          php-pear-Cache.noarch 1.5.6-1.el6 epel
          php-pear-Cache-Lite.noarch 1.7.12-1.el6 epel
          php-pear-CodeGen.noarch 1.0.7-3.el6 epel
          php-pear-CodeGen-PECL.noarch 1.1.3-3.el6 epel
          php-pear-Console-Color.noarch 1.0.3-1.el6 epel
          php-pear-Console-CommandLine.noarch 1.1.3-3.el6 epel
          php-pear-Console-Getargs.noarch 1.3.5-1.el6 epel
          php-pear-Console-ProgressBar.noarch 0.5.2-0.6.beta.el6 epel
          php-pear-Console-Table.noarch 1.1.4-1.el6.2 epel
          php-pear-Crypt-Blowfish.noarch 1.1.0-0.4.rc2.el6 epel
          php-pear-Crypt-CHAP.noarch 1.5.0-1.el6 epel
          php-pear-DB.noarch 1.7.13-3.el6 epel
          php-pear-DB-DataObject.noarch 1.8.12-2.el6 epel
          php-pear-DB-DataObject-FormBuilder.noarch 1.0.0-2.el6 epel
          php-pear-DB-QueryTool.noarch 1.1.2-4.el6 epel
          php-pear-Date.noarch 1.4.7-5.el6 epel
          php-pear-Date-Holidays.noarch 0.21.4-2.el6 epel
          php-pear-Date-Holidays-USA.noarch 0.1.1-4.el6 epel
          php-pear-Event-Dispatcher.noarch 1.1.0-2.el6 epel
          php-pear-File.noarch 1.4.0-1.el6 epel
          php-pear-File-CSV.noarch 1.0.0-2.el6 epel
          php-pear-File-Find.noarch 1.3.1-1.el6 epel
          php-pear-File-Passwd.noarch 1.1.7-2.el6 epel
          php-pear-File-SMBPasswd.noarch 1.0.3-2.el6 epel
          php-pear-File-Util.noarch 1.0.0-2.el6 epel
          php-pear-HTML-Common.noarch 1.2.5-3.el6 epel
          php-pear-HTML-QuickForm.noarch 3.2.12-1.el6 epel
          php-pear-HTML-QuickForm-ElementGrid.noarch 0.1.1-5.el6 epel
          php-pear-HTML-QuickForm-advmultiselect.noarch 1.5.1-3.el6 epel
          php-pear-HTML-Table.noarch 1.8.3-1.el6 epel
          php-pear-HTML_Javascript.noarch 1.1.1-4.el6 epel
          php-pear-HTML_Template_PHPLIB.noarch 1.4.0-2.el6 epel
          php-pear-HTTP.noarch 1.4.1-5.el6 epel
          php-pear-HTTP-Client.noarch 1.2.1-4.el6 epel
          php-pear-HTTP-OAuth.noarch 0.2.2-1.el6 epel
          php-pear-HTTP-Request.noarch 1.4.4-2.el6 epel
          php-pear-HTTP-Request2.noarch 0.5.2-2.el6 epel
          php-pear-HTTP-Upload.noarch 0.9.1-5.el6 epel
          php-pear-Image-Canvas.noarch 0.3.3-1.el6 epel
          php-pear-Image-Color.noarch 1.0.4-1.el6 epel
          php-pear-Image-Graph.noarch 0.8.0-1.el6 epel
          php-pear-Image-GraphViz.noarch 1.3.0-1.el6 epel
          php-pear-Log.noarch 1.12.7-1.el6 epel
          php-pear-MDB2.noarch 2.5.0-0.3.b3.el6 epel
          php-pear-MDB2-Driver-mysql.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Driver-mysqli.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Driver-pgsql.noarch 1.5.0-0.1.b3.el6 epel
          php-pear-MDB2-Schema.noarch 0.8.5-1.el6 epel
          php-pear-Mail.noarch 1.2.0-1.el6 epel
          php-pear-Mail-Mime.noarch 1.8.4-1.el6 epel
          php-pear-Mail-mimeDecode.noarch 1.5.5-1.el6 epel
          php-pear-Math-Stats.noarch 0.9.1-1.el6 epel
          php-pear-Net-Curl.noarch 1.2.5-4.el6 epel
          php-pear-Net-DIME.noarch 1.0.2-1.el6 epel
          php-pear-Net-FTP.noarch 1.3.7-4.el6 epel
          php-pear-Net-IDNA2.noarch 0.1.1-3.el6 epel
          php-pear-Net-POP3.noarch 1.3.8-1.el6 epel
          php-pear-Net-Ping.noarch 2.4.5-2.el6 epel
          php-pear-Net-SMTP.noarch 1.6.1-1.el6 epel
          php-pear-Net-Sieve.noarch 1.3.2-1.el6 epel
          php-pear-Net-Socket.noarch 1.0.10-1.el6 epel
          php-pear-Net-Traceroute.noarch 0.21.3-1.el6 epel
          php-pear-Net-URL.noarch 1.0.15-4.el6 epel
          php-pear-Net-URL-Mapper.noarch 0.9.1-1.el6 epel
          php-pear-Net-URL2.noarch 0.3.1-2.el6 epel
          php-pear-Net-UserAgent-Detect.noarch 2.5.2-1.el6 epel
          php-pear-Numbers-Roman.noarch 1.0.2-5.el6 epel
          php-pear-Numbers-Words.noarch 0.16.2-1.el6 epel
          php-pear-OLE.noarch 1.0.0-0.4.rc1.el6 epel
          php-pear-PHP-CodeSniffer.noarch 1.3.4-1.el6 epel
          php-pear-PHP-Compat.noarch 1.5.0-5.el6 epel
          php-pear-PHP-CompatInfo.noarch 1.9.0-3.el6 epel
          php-pear-Pager.noarch 2.4.8-2.el6 epel
          php-pear-Payment-Process.noarch 0.6.6-5.el6 epel
          php-pear-PhpDocumentor.noarch 1.4.4-1.el6 epel
          php-pear-SOAP.noarch 0.12.0-4.el6 epel
          php-pear-Services-Twitter.noarch 0.6.1-1.el6 epel
          php-pear-Services-Weather.noarch 1.4.5-2.el6 epel
          php-pear-Structures-DataGrid.noarch 0.9.0-6.el6 epel
          php-pear-Structures-DataGrid-DataSource-Array.noarch 0.1.4-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-DataObject.noarch 0.2.1-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-MDB2.noarch 0.1.11-4.el6 epel
          php-pear-Structures-DataGrid-DataSource-RSS.noarch 0.1.1-4.el6 epel
          php-pear-Structures-DataGrid-Renderer-Pager.noarch 0.1.3-4.el6 epel
          php-pear-Structures-DataGrid-Renderer-Smarty.noarch 0.1.5-1.el6 epel
          php-pear-Text-Diff.noarch 1.1.0-2.el6 epel
          php-pear-Validate.noarch 0.8.3-1.el6 epel
          php-pear-Validate-Finance-CreditCard.noarch 0.5.3-4.el6 epel
          php-pear-Var-Dump.noarch 1.0.3-5.el6 epel
          php-pear-XML-Beautifier.noarch 1.2.2-1.el6 epel
          php-pear-XML-Parser.noarch 1.3.4-1.el6 epel
          php-pear-XML-RPC2.noarch 1.0.6-1.el6 epel
          php-pear-XML-RSS.noarch 1.0.1-1.el6 epel
          php-pear-XML-Serializer.noarch 0.20.2-1.el6 epel
          php-pear-phing.noarch 2.4.12-1.el6 epel
          php-pecl-amqp.x86_64 1.0.1-3.el6 epel
          php-pecl-apc.x86_64 3.1.9-2.el6 base
          php-pecl-apc-devel.x86_64 3.1.9-2.el6 base
          php-pecl-geoip.x86_64 1.0.7-4.el6 epel
          php-pecl-gmagick.x86_64 1.1.0-0.2.RC2.el6 epel
          php-pecl-igbinary.i686 1.1.1-3.el6 epel
          php-pecl-igbinary.x86_64 1.1.1-3.el6 epel
          php-pecl-igbinary-devel.i686 1.1.1-3.el6 epel
          php-pecl-igbinary-devel.x86_64 1.1.1-3.el6 epel
          php-pecl-imagick.x86_64 2.2.2-4.el6 epel
          php-pecl-lzf.x86_64 1.5.2-5.el6 epel
          php-pecl-mailparse.x86_64 2.1.5-2.el6 epel
          php-pecl-memcache.x86_64 3.0.5-4.el6 base
          php-pecl-memcached.x86_64 1.0.0-1.el6 epel
          php-pecl-mongo.x86_64 1.2.10-1.el6 epel
          php-pecl-ncurses.x86_64 1.0.1-1.el6 epel
          php-pecl-parsekit.x86_64 1.2-5.CVS20090309.el6 epel
          php-pecl-radius.x86_64 1.2.5-10.el6 epel
          php-pecl-rrd.x86_64 1.0.3-1.el6 epel
          php-pecl-runkit.x86_64 0.9-12.CVS20090215.el6 epel
          php-pecl-solr.x86_64 0.9.11-1.el6 epel
          php-pecl-sphinx.x86_64 1.0.0-2.el6 epel
          php-pecl-ssh2.x86_64 0.11.0-7.el6 epel
          php-pecl-xdebug.x86_64 2.1.4-1.el6 epel
          php-pecl-xhprof.x86_64 0.9.2-5.el6 epel
          php-pgsql.x86_64 5.3.3-14.el6_3 updates
          php-php-gettext.noarch 1.0.11-3.el6 epel
          php-phpmd-PHP-PMD.noarch 1.3.3-1.el6 epel
          php-phpunit-DbUnit.noarch 1.1.2-1.el6 epel
          php-phpunit-File-Iterator.noarch 1.3.1-1.el6 epel
          php-phpunit-PHP-CodeBrowser.noarch 1.0.2-1.el6 epel
          php-phpunit-PHP-CodeCoverage.noarch 1.1.2-1.el6 epel
          php-phpunit-PHP-Invoker.noarch 1.1.0-1.el6 epel
          php-phpunit-PHP-Timer.noarch 1.0.2-2.el6 epel
          php-phpunit-PHP-TokenStream.noarch 1.1.3-1.el6 epel
          php-phpunit-PHPUnit.noarch 3.6.11-1.el6 epel
          php-phpunit-PHPUnit-MockObject.noarch 1.1.1-1.el6 epel
          php-phpunit-PHPUnit-Selenium.noarch 1.2.7-1.el6 epel
          php-phpunit-PHPUnit-SkeletonGenerator.noarch 1.1.0-1.el6 epel
          php-phpunit-Text-Template.noarch 1.1.1-1.el6 epel
          php-phpunit-phpcpd.noarch 1.3.5-1.el6 epel
          php-phpunit-phpdcd.noarch 0.9.3-1.el6 epel
          php-phpunit-phploc.noarch 1.6.2-1.el6 epel
          php-process.x86_64 5.3.3-14.el6_3 updates
          php-pspell.x86_64 5.3.3-14.el6_3 updates
          php-recode.x86_64 5.3.3-14.el6_3 updates
          php-redland.x86_64 1.0.7.1-1.el6 epel
          php-shout.x86_64 0.9.2-6.el6 epel
          php-simplepie.noarch 1.1.3-4.el6 epel
          php-snmp.x86_64 5.3.3-14.el6_3 updates
          php-soap.x86_64 5.3.3-14.el6_3 updates
          php-suhosin.x86_64 0.9.29-2.el6 epel
          php-swift-Swift.noarch 4.1.7-1.el6 epel
          php-symfony-YAML.noarch 1.0.6-1.el6 epel
          php-symfony-symfony.noarch 1.4.18-1.el6 epel
          php-symfony2-BrowserKit.noarch 2.0.15-2.el6 epel
          php-symfony2-ClassLoader.noarch 2.0.15-2.el6 epel
          php-symfony2-Config.noarch 2.0.15-1.el6 epel
          php-symfony2-Console.noarch 2.0.15-1.el6 epel
          php-symfony2-CssSelector.noarch 2.0.15-1.el6 epel
          php-symfony2-DependencyInjection.noarch 2.0.15-3.el6 epel
          php-symfony2-DomCrawler.noarch 2.0.15-2.el6 epel
          php-symfony2-EventDispatcher.noarch 2.0.15-1.el6 epel
          php-symfony2-Finder.noarch 2.0.15-1.el6 epel
          php-symfony2-Form.noarch 2.0.15-4.el6 epel
          php-symfony2-HttpFoundation.noarch 2.0.15-2.el6 epel
          php-symfony2-HttpKernel.noarch 2.0.15-3.el6 epel
          php-symfony2-Locale.noarch 2.0.15-3.el6 epel
          php-symfony2-Process.noarch 2.0.15-1.el6 epel
          php-symfony2-Routing.noarch 2.0.15-3.el6 epel
          php-symfony2-Security.noarch 2.0.15-3.el6 epel
          php-symfony2-Serializer.noarch 2.0.15-1.el6 epel
          php-symfony2-Templating.noarch 2.0.15-1.el6 epel
          php-symfony2-Translation.noarch 2.0.15-4.el6 epel
          php-symfony2-Validator.noarch 2.0.15-4.el6 epel
          php-symfony2-Yaml.noarch 2.0.15-1.el6 epel
          php-tidy.x86_64 5.3.3-14.el6_3 updates
          php-twig-Twig.noarch 1.8.2-1.el6 epel
          php-voms-admin.noarch 0.6-1.el6 epel
          php-xapian.x86_64 1.2.7-1.el6 epel
          php-xmlrpc.x86_64 5.3.3-14.el6_3 updates
          php-zipstream.noarch 0.2.2-1.el6 epel
          php-zmq.x86_64 0.6.0-4.20120613git516bd6f.el6 epel
          php-zts.x86_64 5.3.3-14.el6_3 updates
          phpMyAdmin.noarch 3.5.1-1.el6 epel
          phpPgAdmin.noarch 5.0.4-1.el6 epel
          phpldapadmin.noarch 1.2.2-1.el6 epel
          phpwapmail.noarch 0.9.4-1.el6 epel
          rrdtool-php.x86_64 1.3.8-6.el6 base
          uuid-php.x86_64 1.6.1-10.el6 base
          [indapublic@myserver ~]$ yum --enablerepo=remi repolist
          Loaded plugins: fastestmirror
          Loading mirror speeds from cached hostfile
          * Webmin: download.webmin.com
          * base: mirror.yandex.ru
          * epel: mirror.yandex.ru
          * extras: mirror.yandex.ru
          * remi: rpms.famillecollet.com
          * updates: mirror.yandex.ru
          remi | 2.9 kB 00:00
          remi/primary_db | 273 kB 00:04
          repo id repo name status
          Webmin Webmin Distribution Neutral 118
          base CentOS-6 - Base 6 346
          *epel Extra Packages for Enterprise Linux 6 - x86_64 7 634
          extras CentOS-6 - Extras 4
          remi Les RPM de remi pour Enterprise Linux 6 - x86_64 539
          updates CentOS-6 - Updates 256
          repolist: 14 897
          [indapublic@myserver ~]$

          • Hi again indapublic,

            Try to install it with following command:

            yum --enablerepo=remi,remi-test install phpmyadmin

            You got this error, because you have PHP 5.4 installed from remi-test repo. I updated this guide too.

            • Thank you very much. It works.

              • You are welcome! :)

  9. Hi, I’m having problems after installing phpMyAdmin following the steps here because every time I call pma.devserver or phpMyAdmin.devserver I go to Apache Root Directory instead of /usr/share/phpMyAdmin. I check the phpMyAdmin.conf file and seems to be good and also I change from Deny from All to Allow from All to give access to my PC. I’m using Apache Virtual Host feature under CentOS 6.3 with Apache 2.2.15, any advice?

  10. Hi Indapublic, what you mean with httpd.conf? If is the configuration file you can download from here https://docs.google.com/open?id=0BwyEmER2hZQ7blB6MFZOTHdpV2c

    • Hi ReynierPM,

      Could you post /etc/httpd/conf.d/phpMyAdmin.conf file content?

  11. I think, php is not installed corrrectly. Directoryindex section not contain php extension in httpd.conf

    • I think that the problem might be phpMyAdmin virtual host and server name configuration.

  12. @indapublic PHP is working fine because I access to many WP installations without problems. @JR: Here is the phpMyAdmin.conf file http://pastebin.com/y9rtBb8F

  13. This is not at localhost is on another PC and if I yes I can access

    • Okay, then try http://devserver/phpMyAdmin (or http://devserver/phpmyadmin). So use address which point to your another PC and add phpmyadmin path.

      • Didn’t work at all. I create a new VM using CentOS 6.3 with clean installation just install Apache, PHP, MySQL and then phpMyAdmin and default conf file for VH doesn’t work and can’t find the cause. Maybe Virtual Host is the problem?

        • Is it working from localhost?

  14. 403. :(

    Centos 5.8
    Apache/2.2.3

    nano /etc/httpd/conf.d/phpMyAdmin.conf:

    # Apache 2.4
    Require local

    # Apache 2.2
    Order Deny,Allow
    Deny from All
    Allow from 127.0.0.1
    Allow from 190.xxx.xxx.xxx
    Allow from ::1

    Thanks. EVerything has been very helpful so far.

    • Hi antiwesley,

      Could you post full content of /etc/httpd/conf.d/phpMyAdmin.conf file?

      • # phpMyAdmin - Web based MySQL browser written in php
        #
        # Allows only localhost by default
        #
        # But allowing phpMyAdmin to anyone other than localhost should be considered
        # dangerous unless properly secured by SSL

        Alias /phpMyAdmin /usr/share/phpMyAdmin
        Alias /phpmyadmin /usr/share/phpMyAdmin

        # Apache 2.4
        Require local

        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 127.0.0.1
        Allow from 190.xxx.xx.xxx
        Allow from ::1

        # Apache 2.4
        Require local

        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 190.xxx.xx.xxx
        Allow from 127.0.0.1
        Allow from ::1

        # These directories do not require access over HTTP - taken from the original
        # phpMyAdmin upstream tarball
        #

        Order Deny,Allow
        Deny from All
        Allow from None

        Order Deny,Allow
        Deny from All
        Allow from None

        Order Deny,Allow
        Deny from All
        Allow from None

        # This configuration prevents mod_security at phpMyAdmin directories from
        # filtering SQL etc. This may break your mod_security implementation.
        #
        #
        #
        # SecRuleInheritance Off
        #
        #

        This is what came pre-installed with my LAP… (had to install mySQL myself)

      • Hrm. The Code tag doesn’t like the tags inside it.

        # phpMyAdmin - Web based MySQL browser written in php
        #
        # Allows only localhost by default
        #
        # But allowing phpMyAdmin to anyone other than localhost should be considered
        # dangerous unless properly secured by SSL

        Alias /phpMyAdmin /usr/share/phpMyAdmin
        Alias /phpmyadmin /usr/share/phpMyAdmin

        (Directory /usr/share/phpMyAdmin/)

        (IfModule mod_authz_core.c)
        # Apache 2.4
        Require local
        (/IfModule)
        (IfModule !mod_authz_core.c)
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 127.0.0.1
        Allow from 190.xxx.xx.xxx
        Allow from ::1
        (/IfModule)
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/)
        (IfModule mod_authz_core.c)
        # Apache 2.4
        Require local
        (/IfModule)
        (IfModule !mod_authz_core.c)
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from 190.xxx.xx.xxx
        Allow from 127.0.0.1
        Allow from ::1
        (/IfModule)
        (/Directory)

        # These directories do not require access over HTTP - taken from the original
        # phpMyAdmin upstream tarball
        #
        (Directory /usr/share/phpMyAdmin/libraries/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/lib/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        (Directory /usr/share/phpMyAdmin/setup/frames/)
        Order Deny,Allow
        Deny from All
        Allow from None
        (/Directory)

        # This configuration prevents mod_security at phpMyAdmin directories from
        # filtering SQL etc. This may break your mod_security implementation.
        #
        #(IfModule mod_security.c)
        # (Directory /usr/share/phpMyAdmin/)
        # SecRuleInheritance Off
        # (/Directory)
        #(/IfModule)

        —-
        replace () with

        • Oh, I see. Actually <pre lang=”bash”>Code here</pre> syntax should work better, but I got your config thanks. :)

          Did you try to access phpMyAdmin from localhost?

          • VPS. So unless I can do it from an SSH shell.. then no.

            • You can check it from SSH shell, if you have curl or lynx installed:

              curl -I http://localhost/phpmyadmin
               
              lynx -head -mime_header http://localhost/phpmyadmin
              • [root@server1 /]# curl -I http://localhost/phpmyadmin
                HTTP/1.1 301 Moved Permanently
                Date: Tue, 21 Aug 2012 02:37:47 GMT
                Server: Apache/2.2.3 (CentOS)
                Location: http://localhost/phpmyadmin/
                Connection: close
                Content-Type: text/html; charset=iso-8859-1
                • Sorry, this was my mistake, you need one extra slash (/), could you post again:

                  curl -I http://localhost/phpmyadmin/
                  • HTTP/1.1 200 OK
                    Date: Wed, 22 Aug 2012 05:03:05 GMT
                    Server: Apache/2.2.3 (CentOS)
                    X-Powered-By: PHP/5.4.6
                    Set-Cookie: phpMyAdmin=e3653o786l641kksu3ucelka4ijkdle8; path=/phpmyadmin/; HttpOnly
                    Expires: Thu, 19 Nov 1981 08:52:00 GMT
                    Cache-Control: private, max-age=10800, pre-check=10800
                    Last-Modified: Sun, 12 Aug 2012 13:45:56 GMT
                    Set-Cookie: pma_lang=en; expires=Fri, 21-Sep-2012 05:03:11 GMT; path=/phpmyadmin/; httponly
                    Set-Cookie: pma_collation_connection=utf8_general_ci; expires=Fri, 21-Sep-2012 05:03:11 GMT; path=/phpmyadmin/;
                     httponly
                    Set-Cookie: pma_mcrypt_iv=fHSjSK%2BerYY%3D; expires=Fri, 21-Sep-2012 05:03:12 GMT; path=/phpmyadmin/; httponly
                    Set-Cookie: phpMyAdmin=3c68lvc1dcc2i2jol14ik7ga8bfa03gb; path=/phpmyadmin/; HttpOnly
                    Connection: close
                    Content-Type: text/html; charset=utf-8
                    • Good, it works! :)

                      Now you have to add your ip or subnet to config file:

                      ...
                      Allow from 127.0.0.1
                      Allow from [your ip or subnet here]
                      ...
  15. Both IP’s were already in /etc/httpd/conf.d/phpMyAdmin.conf.

    I just checked to see if mysql was running and it’s not, nor will it let me restart the service. :(

    • Good. Do you have port 80 open on your server?

      netstat -ntulp
      • tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      5789/httpd
        • Okay, looks good.

          Do you get some error when you try to start mysql?

          For more information you could check /var/log/mysqld.log log file.

          • 120822 10:56:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
            120822 10:56:40 [Note] Plugin 'FEDERATED' is disabled.
            120822 10:56:40 InnoDB: The InnoDB memory heap is disabled
            120822 10:56:40 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
            120822 10:56:40 InnoDB: Compressed tables use zlib 1.2.3
            120822 10:56:40 InnoDB: Using Linux native AIO
            120822 10:56:40 InnoDB: Initializing buffer pool, size = 128.0M
            120822 10:56:40 InnoDB: Completed initialization of buffer pool
            InnoDB: Error: pthread_create returned 11
            120822 10:56:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
            • Could you post output of following commands:

              df -h
               
              free -m
               
              cat /etc/my.cnf
              • [root@server1 /]# df -h
                Filesystem            Size  Used Avail Use% Mounted on
                /dev/simfs             10G  694M  9.4G   7% /
                [root@server1 /]#
                [root@server1 /]# free -m
                             total       used       free     shared    buffers     cached
                Mem:           256         63        192          0          0          0
                -/+ buffers/cache:         63        192
                Swap:            0          0          0
                [root@server1 /]#
                [root@server1 /]# cat /etc/my.cnf
                [mysqld]
                # Settings user and group are ignored when systemd is used (fedora >= 15).
                # If you need to run mysqld under different user or group,
                # customize your systemd unit file for mysqld according to the
                # instructions in http://fedoraproject.org/wiki/Systemd
                user=mysql
                
                datadir=/var/lib/mysql
                socket=/var/lib/mysql/mysql.sock
                
                # Disabling symbolic-links is recommended to prevent assorted security risks
                symbolic-links=0
                
                # Semisynchronous Replication
                # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
                # uncomment next line on MASTER
                ;plugin-load=rpl_semi_sync_master=semisync_master.so
                # uncomment next line on SLAVE
                ;plugin-load=rpl_semi_sync_slave=semisync_slave.so
                
                # Others options for Semisynchronous Replication
                ;rpl_semi_sync_master_enabled=1
                ;rpl_semi_sync_master_timeout=10
                ;rpl_semi_sync_slave_enabled=1
                
                # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
                ;performance_schema
                
                [mysqld_safe]
                log-error=/var/log/mysqld.log
                pid-file=/var/run/mysqld/mysqld.pid
                
                • Your error InnoDB: Error: pthread_create returned 11 sounds like a memory problem, do you need InnoDB?

                  If not, then you could add following to your /etc/my.cnf:

                  skip-innodb

                  And try to start mysqld.

                  • Yes, it was a memory issue, and thanks to some Google-Fu, I was able to fix that.
                    httpd and mysql are running, but they are both using up a lot of the memory to begin with.
                    Both /phpmyadmin and /phpMyAdmin are 403’ing in my webbrowser, and still giving the okay in the terminal.

                    • Okay, sounds good. :)

                      To correct that 403 error I recommend you to test first what happens if allow all traffic temporarily, change config to:

                      <Directory /usr/share/phpMyAdmin/>
                         <IfModule mod_authz_core.c>
                           # Apache 2.4
                           Require local
                         </IfModule>
                         <IfModule !mod_authz_core.c>
                           # Apache 2.2
                           Order Allow,Deny
                           Allow from All
                         </IfModule>
                      </Directory>

                      Restart httpd and try to access phpMyAdmin, is it working then or do you still get 403 error?

  16. It’s working now. The only problem I have to work out is that I forgot the user/pass combination I had set up and Google-Fu isn’t helping. Lots of solutions, but nothing works yet.

    But thank you again for the help on this. It was a bit of a pain, and I’ll be upping the memory ASAP on the server so it’ll work a bit better.

  17. yum –enablerepo=remi install phpmyadmin will fetch v 2.11 from rpmforg which is realy old insted type:

    yum –enablerepo=remi install phpMyAdmin

    which install 3.5.2.2 from epel

    • Hi pouya,

      Yes, this depends what repositories you have installed, but if you want install it from remi repository, then you need to disable other not needed repos and install it from remi repo.

      • hi JR

        In both statements we declare remi as our repo. i’m confused why we shouldn’t type

        yum –enablerepo=epel install phpMyAdmin

        if it’s possible please elaborate more

        thanks i bookmarked your site and always check it for useful and uptodate tutorials

        • remi repo only contains 2.11 not 3.5.2

          • Hi pouya,

            I said that you have to disable epel & rpmforge and enable remi:

            yum --disablerepo=epel,rpmforge --enablerepo=remi install phpMyAdmin

            Could you also post output of following commands:

            uname -a
             
            lsb_release -a
             
            yum repolist
             
            yum --disablerepo=* --enablerepo=remi list phpMyAdmin

            My output from remi repo is following:

            yum --disablerepo=* --enablerepo=remi list phpMyAdmin
            Loaded plugins: fastestmirror
            Loading mirror speeds from cached hostfile
             * remi: fr2.rpmfind.net
            Installed Packages
            phpMyAdmin.noarch                    3.5.2.2-1.el6.remi                    @remi

            So I see currently only phpMyAdmin 3.5.2.2 on remi repository.

  18. I’ve install nginx, php, mysql and phpmyadmin following this site’s essays. I can access http://pma/ now, while http://localhost/phpmyadmin/ is denied (404). What should I check?

  19. JR As I was saying I’ back :). Sorry to bother you but I’m a linux noob.

    Followed your instructions wit success.
    My issue is that since this is a VPS I don’t have aces to localhost. therefore I must access phpmyadmin from web.

    How Do I do that. I’ve tried putting local host /phpmyadmin in the virtual host config with no success.
    Also tried putting it in default config without results.

    Thanks !

    • Hi again Mosfet :)

      This is exactly reason why I run this site, try to help other users, so feel free to ask. :D

      First a couple of questions…so you are using nginx setup, right? Do you have some domain pointing to this server and you have control to subdomains?

      • At this moment I have 2 domains pointing to the server. In test both work fine.
        But when I’m trying to access phpmyadmin all I get is an empty page.

        Tried the /phpmyadmin method posted in the comments and changing the “pma” in examples with my actual domain expecting to load phpmysql when accessing domain.tld to get phpmyadmin.

        • Ok, then if possible create subdomain which point to your server too:
          pma.domain.tld

          Then create virtual host file, like:

          server {
                 listen   80;
                 server_name pma.domain.tld;       access_log /var/log/nginx/phpmyadmin/access.log;
                 error_log /var/log/nginx/phpmyadmin/error.log;
                 root /usr/share/phpMyAdmin;
           
                 location / {
                     index  index.php;
                 }
           
                 ## Images and static content is treated different
                 location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
                     access_log        off;
                     expires           360d;
                 }
           
                 location ~ /\.ht {
                     deny  all;
                 }
           
                 location ~ /(libraries|setup/frames|setup/libs) {
                     deny all;
                     return 404;
                 }
           
                 location ~ \.php$ {
                     include /etc/nginx/fastcgi_params;
                     fastcgi_pass 127.0.0.1:9000;
                     fastcgi_index index.php;
                     fastcgi_param SCRIPT_FILENAME /usr/share/phpMyAdmin$fastcgi_script_name;
                 }
          }

          Restart Nginx and try to access http://pma.domain.tld

          • Hi, in order to make this more easy I’ve registered a .tk tld.

            I’ve created virtual host file for that domain and tested with a hello world php example. The test and domain is http://www.phpmyadmintestdomain.tk and as you can see the “hello world ” is working just fine.

            After this :
            – I’ve created and pointed the subdomain myadmin.phpmyadmintestdomain.tk to the VPS server.
            – Made a virtual-host file ( /etc/nginx/sites-available/myadmin.phpmyadmintestdomain.tk ) and a link to thesame file in /etc/nginx/sites-enabled.
            – restart nginx ( service nginx restart )

            Without any results. Also you can access the domain and subdomain.

            THANKS !

            • This is the content of /var/log/nginx/phpmyadmin/error.log


              2012/10/27 02:15:50 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:15:53 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:15:57 [error] 22242#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:17:56 [error] 22242#0: *8 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:18:09 [error] 22242#0: *8 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"
              2012/10/27 02:18:20 [error] 22269#0: *1 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: xxx.xxx.xxx.xxx (MY IP), server : myadmin.phpmyadmintestdomain.tk, request: "GET / HTTP/1.1", upstream: "fastcgi ://127.0.0.1:9000", host: "myadmin.phpmyadmintestdomain.tk"

          • Right after submitting this message I’ve reloaded the subdomain and got this message

            phpMyAdmin – Error

            Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

          • On further investigation I found that PHP-FPM crashes.

            PHP-FPM error.log :
            WARNING: [pool www] child 910 exited on signal 11 (SIGSEGV) after 1027.210867 seconds from start

  20. Virtualhost: http://pastebin.com/FcWn0csJ
    php-fpm pool conf : http://pastebin.com/hkkqrhNj

    Hope I got the right files.

    • Thanks, looks right files…could you post output of following command here:

      ls -la /var/lib/php
  21. ls -la /var/lib/php
    total 12
    drwxr-xr-x 3 root root 4096 Oct 26 05:22 .
    drwxr-xr-x 20 root root 4096 Oct 26 05:34 ..
    drwxrwx— 2 root apache 4096 Oct 18 13:08 session

    • Okay, problem is your php session path permissions you run php-fpm as nginx:nginx (user:group) and it can’t access session storage, because it have root:apache permissions. You have two option to fix this.

      1. Change following lines on php-fpm pool conf:
      From

      ; RPM: apache Choosed to be able to access some dir as httpd
      user = nginx
      ; RPM: Keep a group allowed to write in log dir.
      group = nginx

      To:

      ; RPM: apache Choosed to be able to access some dir as httpd
      user = apache
      ; RPM: Keep a group allowed to write in log dir.
      group = apache

      Restart PHP-FPM.

      2. Change /var/lib/php/session user and group to nginx

      chown -R root:nginx /var/lib/php/session

      Or

      chown -R nginx:nginx /var/lib/php/session

      Then try again access phpMyAdmin.

  22. It works !

    Thanks for all your help and time !

    • Excellent! :) You are welcome!

  23. It finally works ! and by that I mean submitting messages to your blog (I’ve been trying for 3 days)

    • Really, did you got any error messages?

  24. Works 4 me. CENTOS 6.3

    Thank you !!!

  25. Hi,
    Great tutorial, but I am having a strange issue I can not find anywhere.
    running CentOS 6.3
    Apache 2.2.15
    php 5.4.8
    MySQL 5.5.28

    when I go to http://mysite.com/phpmyadmin I get this on the screen.
    phpMyAdmin –

    I installed phpMyAdmin with Yum, following your tutorial.

    When I put phpMyAdmin in one of my websites public_html directories it works fine. I would rather have it in the /usr/shared/phpMyAdmin directory though.
    I installed SquirrelMail in the /usr/shared/squirrelmail directory, and it works as it is suppose to. I have tried a few different versions of phpMyAdmin and get the same thing.

    Doing the command curl -I http://localhost/phpmyadmin from the ssh I get this.
    [root@server ~]# curl -I http://localhost/phpmyadmin
    HTTP/1.1 301 Moved Permanently
    Date: Tue, 06 Nov 2012 14:18:31 GMT
    Server: Apache/2.2.15
    Location: http://localhost/phpmyadmin/
    Connection: close
    Content-Type: text/html; charset=iso-8859-1
    [root@server ~]#

    Any suggestions?

    Thanks,

    • Hi Micahel,

      What you get when you try:

      curl -I http://localhost/phpmyadmin/

      Note trailing slash.

      • Hi,
        Okay, this is what I get.

        [root@server ~]# curl -I http://localhost/phpmyadmin/
        HTTP/1.1 200 OK
        Date: Wed, 07 Nov 2012 07:08:04 GMT
        Server: Apache/2.2.15
        X-Powered-By: PHP/5.4.8
        Set-Cookie: phpMyAdmin=r4e2ha0okkfj38m3hrv0aruaiqhmq64s; path=/phpmyadmin/; HttpOnly
        Expires: Thu, 19 Nov 1981 08:52:00 GMT
        Cache-Control: private, max-age=10800, pre-check=10800
        Last-Modified: Mon, 08 Oct 2012 15:21:21 GMT
        Set-Cookie: pma_lang=en; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: pma_collation_connection=utf8_general_ci; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: pma_mcrypt_iv=VFpjxiI5%2FHM%3D; expires=Fri, 07-Dec-2012 07:08:04 GMT; path=/phpmyadmin/; httponly
        Set-Cookie: phpMyAdmin=4rt305508u7kfvkrusubabpk0oar0k00; path=/phpmyadmin/; HttpOnly
        Connection: close
        Content-Type: text/html; charset=utf-8

        • Okay, looks like it’s working normally from localhost, so could you post output of following command:

          cat /etc/httpd/conf.d/phpMyAdmin.conf
          • Hi, thanks, here is my phpMyAdmin.conf file.
            I can change it to allow all so you can see exactly what it is, or is not doing.

            # phpMyAdmin – Web based MySQL browser written in php
            #
            # Allows only localhost by default
            #
            # But allowing phpMyAdmin to anyone other than localhost should be considered
            # dangerous unless properly secured by SSL

            Alias /phpMyAdmin /usr/share/phpMyAdmin
            Alias /phpmyadmin /usr/share/phpMyAdmin

            # Apache 2.4
            Require local

            # Apache 2.2
            Order Deny,Allow
            Deny from All
            Allow from 127.0.0.1
            Allow from 72.8.251.26
            Allow from ::1

            # Apache 2.4
            Require local

            # Apache 2.2
            Order Deny,Allow
            Deny from All
            Allow from 127.0.0.1
            Allow from ::1

            # These directories do not require access over HTTP – taken from the original
            # phpMyAdmin upstream tarball
            #

            Order Deny,Allow
            Deny from All
            Allow from None

            Order Deny,Allow
            Deny from All
            Allow from None

            Order Deny,Allow
            Deny from All
            Allow from None

            # This configuration prevents mod_security at phpMyAdmin directories from
            # filtering SQL etc. This may break your mod_security implementation.
            #
            #
            #
            # SecRuleInheritance Off
            #
            #

            • Hi Michael,

              Thanks! It should work if your external ip is that 72.8…and you have reloaded/restarted httpd after this change. Could you also check your httpd access and error logs, and check if you have something suspicious there?

              • Thanks for the help. I went to access it so it could be the most recent in the logs and it worked. No clue why it started working all of a sudden. I have not done anything to the server sense the last time I tried it and it did not work.

                Thanks again.

                • You are very welcome!

                  Nice to hear that you got it working. Hard to say what the problem was, because your configuration is right, maybe it was due the browser cache…

  26. This worked seamlessly. Had one issue with allowing external IP’s and it was answered in the comments. Much appreciated.

  27. hi JR, questions like antiwesley, and I’ve tried to follow the steps in order to solve my problem. but my problem is not likely to INNO-db. is because when I look at the log (var / log / mysqld.log) there is no indication of a problem in the INNO-db.
    and still not be able to access my phpmyadmin (Forbidden

    You do not have permission to access / phpmyadmin / on this server.
    Apache/2.2.3 (CentOS) Server at 192.xxx.xxx.xxx port 80)

    you help me get this problem.

    • Hi Adji,

      Could you try same on localhost, example using curl, and post output:

      curl -I http://localhost/phpmyadmin
  28. [root@MyWebSVR ~]# curl -I http://localhost/phpmyadmin
    HTTP/1.1 301 Moved Permanently
    Date: Thu, 13 Jun 2013 01:40:22 GMT
    Server: Apache/2.2.3 (CentOS)
    Location: http://localhost/phpmyadmin/
    Connection: close
    Content-Type: text/html; charset=iso-8859-1

    • Oh my mistake, actually right command is same with slash:

      curl -I http://localhost/phpmyadmin/

      But actually looks like, it’s running.

      So then check /etc/httpd/conf.d/phpMyAdmin.conf and add following:

      <Directory /usr/share/phpMyAdmin/>
         <IfModule mod_authz_core.c>
           # Apache 2.4
           Require local
         </IfModule>
         <IfModule !mod_authz_core.c>
           # Apache 2.2
           Order Deny,Allow
           Deny from All
           Allow from 127.0.0.1
           Allow from ::1
           Allow from [your external ip address here]   </IfModule>
      </Directory>

      And then restart apache:

      /etc/init.d/httpd restart
       
      ## OR ##
       
      service httpd restart
  29. This using curl and post output :

    [root@MyWebSVR ~]# curl -I http://localhost/phpmyadmin/
    HTTP/1.1 403 Forbidden
    Date: Fri, 14 Jun 2013 13:43:34 GMT
    Server: Apache/2.2.3 (CentOS)
    Connection: close
    Content-Type: text/html; charset=iso-8859-1

    And This is my /etc/httpd/conf.d/phpMyAdmin.conf :

    # Apache 2.4
    Require local

    # Apache 2.2
    Order Deny,Allow
    Deny from All
    Allow from 127.0.0.1
    Allow from ::1
    Allow from 192.168.1.67

    I’ve followed the steps you give, but the problem still remains the same. “Forbidden

    You do not have permission to access / phpmyadmin / on this server.
    Apache/2.2.3 (CentOS) Server at 192.xxx.xxx.xxx Port 80 “

    • Could you also post output of following command:

      curl -I http://127.0.0.1/phpmyadmin/
  30. I followed below mentioned steps but it failed due to dependencies. Please help.

    Step 1: rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
    Step 2: rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
    Step 3: yum –enablerepo=remi,remi-test install phpmyadmin

    Output of above is:
    Loaded plugins: aliases, changelog, downloadonly, kabi, presto, refresh-packagekit, security, tmprepo, verify, versionlock
    Loading support for Red Hat kernel ABI
    Setting up Install Process
    Resolving Dependencies
    –> Running transaction check
    —> Package phpMyAdmin.noarch 0:3.5.8.1-1.el6 will be installed
    –> Processing Dependency: php-mysql >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Running transaction check
    —> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
    –> Processing Dependency: php-mbstring for package: php-php-gettext-1.0.11-3.el6.noarch
    —> Package phpMyAdmin.noarch 0:3.5.8.1-1.el6 will be installed
    –> Processing Dependency: php-mysql >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.8.1-1.el6.noarch
    –> Finished Dependency Resolution
    Error: Package: php-php-gettext-1.0.11-3.el6.noarch (epel)
    Requires: php-mbstring
    Error: Package: phpMyAdmin-3.5.8.1-1.el6.noarch (epel)
    Requires: php-gd >= 5.2.0
    Error: Package: phpMyAdmin-3.5.8.1-1.el6.noarch (epel)
    Requires: php-mbstring >= 5.2.0
    Error: Package: phpMyAdmin-3.5.8.1-1.el6.noarch (epel)
    Requires: php-mysql >= 5.2.0
    You could try using –skip-broken to work around the problem
    You could try running: rpm -Va –nofiles –nodigest

  31. Hi JR,

    I tried to follow your steps. I install Remi repository.


    • [website1@website1 ~]$ sudo rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
      [sudo] password for website1:
      Retrieving http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
      warning: /var/tmp/rpm-tmp.8OGCXY: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
      Preparing... ########################################### [100%]
      package epel-release-6-8.noarch is already installed
      [website1@website1 ~]$ sudo rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
      Retrieving http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
      warning: /var/tmp/rpm-tmp.nSb289: Header V3 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
      Preparing... ########################################### [100%]
      package remi-release-6.5-1.el6.remi.noarch is already installed
      [website1@website1 ~]$

    • I install phpMyAdmin.


      [website1@website1 ~]$ sudo yum --enablerepo=remi install phpmyadmin
      [sudo] password for website1:
      Loaded plugins: fastestmirror, refresh-packagekit, security

      Error getting repository data for remi, repository not found
      [website1@website1 ~]$ sudo yum --enablerepo=remi,remi-test install phpmyadmin
      Loaded plugins: fastestmirror, refresh-packagekit, security
      Loading mirror speeds from cached hostfile
      * base: mirror.upsi.edu.my
      * extras: centos.mirror.secureax.com
      * updates: ossm.utm.my
      Setting up Install Process
      No package phpmyadmin available.
      Error: Nothing to do
      [website1@website1 ~]$

      • Hi dhenyismail,

        Please run first following command:

        yum clean all

        Then, could you post output of following commands:

        yum --enablerepo=remi repolist
         
        yum --enablerepo=remi info phpmyadmin
  32. Hi!
    Great tutorial, but I have a minor problem.
    When I try to install phpmyadmin with:


    yum --enablerepo=remi install phpmyadmin

    ## And

    yum --enablerepo=remi,remi-test install phpmyadmin

    I get these errors:


    Error: Package: php-bcmath-5.4.28-1.el6.remi.x86_64 (remi)
    Requires: php-common(x86-64) = 5.4.28-1.el6.remi
    Installed: php-common-5.5.12-1.el6.remi.x86_64 (@remi-php55)
    php-common(x86-64) = 5.5.12-1.el6.remi
    Available: php-common-5.3.3-26.el6.x86_64 (base)
    php-common(x86-64) = 5.3.3-26.el6
    Available: php-common-5.3.3-27.el6_5.x86_64 (updates)
    php-common(x86-64) = 5.3.3-27.el6_5
    Available: php-common-5.4.27-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.27-1.el6.remi
    Available: php-common-5.4.28-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.28-1.el6.remi
    Error: Package: php-recode-5.4.28-1.el6.remi.x86_64 (remi)
    Requires: php-common(x86-64) = 5.4.28-1.el6.remi
    Installed: php-common-5.5.12-1.el6.remi.x86_64 (@remi-php55)
    php-common(x86-64) = 5.5.12-1.el6.remi
    Available: php-common-5.3.3-26.el6.x86_64 (base)
    php-common(x86-64) = 5.3.3-26.el6
    Available: php-common-5.3.3-27.el6_5.x86_64 (updates)
    php-common(x86-64) = 5.3.3-27.el6_5
    Available: php-common-5.4.27-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.27-1.el6.remi
    Available: php-common-5.4.28-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.28-1.el6.remi
    Error: Package: php-tidy-5.4.28-1.el6.remi.x86_64 (remi)
    Requires: php-common(x86-64) = 5.4.28-1.el6.remi
    Installed: php-common-5.5.12-1.el6.remi.x86_64 (@remi-php55)
    php-common(x86-64) = 5.5.12-1.el6.remi
    Available: php-common-5.3.3-26.el6.x86_64 (base)
    php-common(x86-64) = 5.3.3-26.el6
    Available: php-common-5.3.3-27.el6_5.x86_64 (updates)
    php-common(x86-64) = 5.3.3-27.el6_5
    Available: php-common-5.4.27-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.27-1.el6.remi
    Available: php-common-5.4.28-1.el6.remi.x86_64 (remi)
    php-common(x86-64) = 5.4.28-1.el6.remi
    Error: Package: phpMyAdmin-4.1.14-1.el6.remi.noarch (remi)
    Requires: php-gmp
    Available: php-common-5.3.3-26.el6.x86_64 (base)
    php-gmp
    Available: php-common-5.3.3-27.el6_5.x86_64 (updates)
    php-gmp
    Available: php-common-5.4.27-1.el6.remi.x86_64 (remi)
    php-gmp
    Available: php-common-5.4.28-1.el6.remi.x86_64 (remi)
    php-gmp
    Installed: php-common-5.5.12-1.el6.remi.x86_64 (@remi-php55)
    Not found
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest

    I’ve tried doing the yum clean all. So here’s the output of yum –enablerepo repolist and yum –enablerepo=remi info phpmyadmin:


    [root@Snoopy ~]# yum --enablerepo=remi repolist
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * base: mirror.fysik.dtu.dk
    * epel: mirrors.coreix.net
    * extras: mirror.informatik.hs-fulda.de
    * remi: mirror.1000mbps.com
    * updates: ftp.plusline.de
    repo id repo name status
    base CentOS-6 - Base 6,367
    epel Extra Packages for Enterprise Linux 6 - x86_64 10,769
    extras CentOS-6 - Extras 14
    nginx nginx repo 56
    remi Les RPM de remi pour Enterprise Linux 6 - x86_64 1,494
    updates CentOS-6 - Updates 883
    repolist: 19,583

    [root@Snoopy ~]# yum --enablerepo=remi info phpmyadmin
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * base: mirror.fysik.dtu.dk
    * epel: mirrors.coreix.net
    * extras: mirror.informatik.hs-fulda.de
    * remi: mirror.1000mbps.com
    * updates: ftp.plusline.de
    Available Packages
    Name : phpMyAdmin
    Arch : noarch
    Version : 4.1.14
    Release : 1.el6.remi
    Size : 4.7 M
    Repo : remi
    Summary : Web based MySQL browser written in php
    URL : http://www.phpmyadmin.net/
    License : GPLv2+
    Description : phpMyAdmin is a tool written in PHP intended to handle the administration of
    : MySQL over the Web. Currently it can create and drop databases,
    : create/drop/alter tables, delete/edit/add fields, execute any SQL statement,
    : manage keys on fields, manage privileges,export data into various formats and
    : is available in 50 languages

    Oh, and other informations:

    OS: CentOS 6.5 (Final)
    Web service: nginx
    PHP version: 5.5.12

    I hope you can help me resolve these problems.

    • Hi UltraG33k,

      I have to update this guide, when I have time to test this on every system.

      Try following install command instead:

      yum --enablerepo=remi,remi-php55 install phpmyadmin
  33. That worked perfectly! Thanks again for a great tutorial :)

    • Excellent, you are welcome! I will update and check this guide soon with latest version.

  34. Hello, I struggled for two days and fail to install phpmyadmin.
    My configuration is: vps, centos 6, nginx, mysql. I tried everything you wrote and every time I get “This page can’t be displayed”. I do not know what to do, perhaps I’ll send my account details that you look there?

    Thanks for everything you do for us.

  35. Now I have this error:


    [root@jocurionlinegratis ~]# service nginx start
    Starting nginx: nginx: [emerg] unknown directive "PK" in /etc/nginx/sites-enabled/phpMyAdmin-4.2.0-all-languages.zip:2
    [FAILED]
    [root@jocurionlinegratis ~]#

  36. Hi JR,

    I have RHEL server 6.5. I followed your instructions to installed Apache 2.2, PHP 5.5.13, MySQL 5.5.38. They work great!
    However when I install phpmyadmin with yum –enablerepo=remi,remi-php55 install phpmyadmin
    I got this error:
    Error: Package: php-recode-5.5.13-3.el6.remi.x86_64 (remi-php55)
    Requires: librecode.so.0()(64bit)
    You could try using –skip-broken to work around the problem
    You could try running: rpm -Va –nofiles –nodigest

    Would you please help me out? Thanks a lot!
    Isabella

  37. Hi JR,

    I follow your instruction to install Apache Server, MySQL and phpadmin.
    However, after the installation, I got a 404 not found error when I try to test myphpmin on http://localhost/phpmyadmin.
    Is there anything I can check to find out the problem?
    Thanks a lot!!

    • I found the solution!

      Just to soft link the folder from /usr/share/phpMyAdmin to /var/www/html:
      sudo ln -s /usr/share/phpMyAdmin /var/www/html/phpMyAdmin

      Thanks a lot!!

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>